Table: Interaction_Contact
Links an Interaction to zero or more Contacts. Each combination of Interaction and Contact must be unique.
Columns
Name | Type | Constraints | Description
interaction_KEY | int | NOT NULL | A reference to one of the Interaction rows.
contact_KEY | int | NOT NULL | A reference to one of the Contact rows.
interaction_association_KEY | tinyint (3) | NOT NULL |

Primary key
Name | Columns | Description
PK_Interaction_Contact$interaction_KEY$contact_KEY$interaction_association_KEY | interaction_KEY, contact_KEY, interaction_association_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Interaction_Contact$contact_KEY | contact_KEY |
IX_Interaction_Contact$interaction_association_KEY | interaction_association_KEY | Index supports foreign key FK_Interaction_Contact__Interaction_Association__interaction_association_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Interaction_Contact__Contact__contact_KEY | contact_KEY | Contact | on delete cascade;
FK_Interaction_Contact__Interaction__interaction_KEY | interaction_KEY | Interaction | on delete cascade;
FK_Interaction_Contact__Interaction_Association__interaction_association_KEY | interaction_association_KEY | Interaction_Association |