Table: Interaction_Association
SYSTEM TABLE: Defines types of association that a Contact can have to an Interaction.
Tags: read-only

Content:
0Contact10
1Staff01
2Originator01
3Of01
Columns
NameTypeConstraintsDescription
interaction_association_KEYtinyint (3)NOT NULLA unique value assigned to this row so that linking to this row uses only 1 byte. Stored as an Int8 to save storage space on the millions of Interaction rows.
descriptionnvarchar (250)NOT NULLThe type of association that a Contact has to an Interaction.
associate_with_contactbitNOT NULLTrue when this type of association is an association between an Interaction and a Contact.
associate_with_objectbitNOT NULLTrue when this type of association is an association between an Interaction and a "object" like a Staff, Client or Office..
Primary key
NameColumnsDescription
PK_Interaction_Association$interaction_association_KEYinteraction_association_KEYCLUSTERED
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction_Contact__Interaction_Association__interaction_association_KEYinteraction_association_KEYInteraction_Contact

Schema diagram