Holds all of the interactions regardless of type and what they are associated with. |
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_utc | datetime | NOT NULL | Date and time of this interaction in UTC. |
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 |
PK_Interaction$interaction_KEY | interaction_KEY | CLUSTERED |
IX_Interaction$entry_date_utc | entry_date_utc | |
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 |