Table: Interaction_Link
Contains additional information about links to Interaction items.
Columns
NameTypeConstraintsDescription
link_KEYintNOT NULLPrimary key, and key to parent table
interaction_KEYintNOT NULLKey to the interaction that this link links to
create_date_utcdatetimeNOT NULL
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Interaction_Link$link_KEYlink_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Interaction_Link$interaction_KEYinteraction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Interaction_Link__Interaction__interaction_KEYinteraction_KEYInteraction
FK_Interaction_Link__Link__link_KEYlink_KEYLink

Schema diagram