Table: Interaction
Holds all of the interactions regardless of type and what they are associated with.
Columns
Name | Type | Constraints | Description
interaction_KEY | int | NOT NULL | Assigned 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_KEY | tinyint (3) | NOT NULL | A 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 | datetime | NOT NULL | Date and time of this interaction.
subject | nvarchar (50) | NOT NULL | The subject of the interaction, currently limited to 50 characters.
body | nvarchar (-1) | NOT NULL | Body of this interaction, sometimes unused (empty string) and sometimes truncated (e-mail body for example.)
priority_KEY | int | NOT NULL |
integration_application_KEY | int | NOT NULL |
cleared | bit | NOT NULL |
file_transfer_event_KEY | int |  | File Transfer event that this Interaction was created for

Primary key
Name | Columns | Description
PK_Interaction$interaction_KEY | interaction_KEY | CLUSTERED
Indexes
Name | Columns | Description
IX_Interaction$entry_date | entry_date |
IX_Interaction$file_transfer_event_KEY | file_transfer_event_KEY | Index supports foreign key FK_Interaction__File_Transfer_Event__file_transfer_event_KEY
IX_Interaction$integration_application_KEY | integration_application_KEY | Index supports foreign key FK_Interaction__Integration_Application__integration_application_KEY
IX_Interaction$interaction_subtype_KEY | interaction_subtype_KEY | Index supports foreign key FK_Interaction__Interaction_Subtype__interaction_subtype_KEY
IX_Interaction$priority_KEY | priority_KEY | Index supports foreign key FK_Interaction__Priority__priority_KEY

Foreign keys
Name | Columns | Referenced table | Description
FK_Interaction__File_Transfer_Event__file_transfer_event_KEY | file_transfer_event_KEY | File_Transfer_Event |
FK_Interaction__Integration_Application__integration_application_KEY | integration_application_KEY | Integration_Application |
FK_Interaction__Interaction_Subtype__interaction_subtype_KEY | interaction_subtype_KEY | Interaction_Subtype |
FK_Interaction__Priority__priority_KEY | priority_KEY | Priority |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction_Contact__Interaction__interaction_KEY | interaction_KEY | Interaction_Contact | on delete cascade;
FK_Interaction_Email_Address__Interaction__interaction_KEY | interaction_KEY | Interaction_Email_Address | on delete cascade;
FK_Interaction_Link__Interaction__interaction_KEY | interaction_KEY | Interaction_Link |
FK_Interaction_Phone_Number__Interaction__interaction_KEY | interaction_KEY | Interaction_Phone_Number |
FK_Outlook_Item__Interaction__interaction_KEY | interaction_KEY | Outlook_Item | on delete cascade;