Table: Interaction
Holds all of the interactions regardless of type and what they are associated with.
Columns
NameTypeConstraintsDescription
interaction_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. A unique value assigned to this row so that linking to this row uses only 4 bytes.
interaction_subtype_KEYtinyint (3)NOT NULLA reference to Interaction_Subtype that indicates what subtype of interaction this is (E-mail, Note, Incoming Phone Call, Outgoing Phone Call, Please Call Back, or Will Call Back, Returned Your Call Phone Message etc.) The Interaction_Subtype table holds a reference to the main Interaction_Type.
entry_date_utcdatetimeNOT NULLDate and time of this interaction in UTC.
subjectnvarchar (50)NOT NULLThe subject of the interaction, currently limited to 50 characters.
bodynvarchar (-1)NOT NULLBody of this interaction, sometimes unused (empty string) and sometimes truncated (e-mail body for example.)
priority_KEYintNOT NULL
integration_application_KEYintNOT NULL
clearedbitNOT NULL
file_transfer_event_KEYintFile Transfer event that this Interaction was created for
Primary key
NameColumnsDescription
PK_Interaction$interaction_KEYinteraction_KEYCLUSTERED
Indexes
NameColumnsDescription
IX_Interaction$entry_date_utcentry_date_utc
IX_Interaction$file_transfer_event_KEYfile_transfer_event_KEYIndex supports foreign key FK_Interaction__File_Transfer_Event__file_transfer_event_KEY
IX_Interaction$integration_application_KEYintegration_application_KEYIndex supports foreign key FK_Interaction__Integration_Application__integration_application_KEY
IX_Interaction$interaction_subtype_KEYinteraction_subtype_KEYIndex supports foreign key FK_Interaction__Interaction_Subtype__interaction_subtype_KEY
IX_Interaction$priority_KEYpriority_KEYIndex supports foreign key FK_Interaction__Priority__priority_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Interaction__File_Transfer_Event__file_transfer_event_KEYfile_transfer_event_KEYFile_Transfer_Event
FK_Interaction__Integration_Application__integration_application_KEYintegration_application_KEYIntegration_Application
FK_Interaction__Interaction_Subtype__interaction_subtype_KEYinteraction_subtype_KEYInteraction_Subtype
FK_Interaction__Priority__priority_KEYpriority_KEYPriority
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction_Contact__Interaction__interaction_KEYinteraction_KEYInteraction_Contacton delete cascade;
FK_Interaction_Email_Address__Interaction__interaction_KEYinteraction_KEYInteraction_Email_Addresson delete cascade;
FK_Interaction_Link__Interaction__interaction_KEYinteraction_KEYInteraction_Link
FK_Interaction_Phone_Number__Interaction__interaction_KEYinteraction_KEYInteraction_Phone_Number
FK_Outlook_Item__Interaction__interaction_KEYinteraction_KEYOutlook_Itemon delete cascade;

Schema diagram