Table: Interaction_Contact
Links an Interaction to zero or more Contacts. Each combination of Interaction and Contact must be unique.
Columns
NameTypeConstraintsDescription
interaction_KEYintNOT NULLA reference to one of the Interaction rows.
contact_KEYintNOT NULLA reference to one of the Contact rows.
interaction_association_KEYtinyint (3)NOT NULL
Primary key
NameColumnsDescription
PK_Interaction_Contact$interaction_KEY$contact_KEY$interaction_association_KEYinteraction_KEY, contact_KEY, interaction_association_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Interaction_Contact$contact_KEYcontact_KEY
IX_Interaction_Contact$interaction_association_KEYinteraction_association_KEYIndex supports foreign key FK_Interaction_Contact__Interaction_Association__interaction_association_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Interaction_Contact__Contact__contact_KEYcontact_KEYContacton delete cascade;
FK_Interaction_Contact__Interaction__interaction_KEYinteraction_KEYInteractionon delete cascade;
FK_Interaction_Contact__Interaction_Association__interaction_association_KEYinteraction_association_KEYInteraction_Association

Schema diagram