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 |