Table: Interaction_Association
SYSTEM TABLE: Defines types of association that a Contact can have to an Interaction. Tags: read-only Content:
0 | Contact | 1 | 0
1 | Staff | 0 | 1
2 | Originator | 0 | 1
3 | Of | 0 | 1
Columns
Name | Type | Constraints | Description
interaction_association_KEY | tinyint (3) | NOT NULL | A 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.
description | nvarchar (30) | NOT NULL | The type of association that a Contact has to an Interaction.
associate_with_contact | bit | NOT NULL | True when this type of association is an association between an Interaction and a Contact.
associate_with_object | bit | NOT NULL | True when this type of association is an association between an Interaction and a "object" like a Staff, Client or Office..

Primary key
Name | Columns | Description
PK_Interaction_Association$interaction_association_KEY | interaction_association_KEY | CLUSTERED

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction_Contact__Interaction_Association__interaction_association_KEY | interaction_association_KEY | Interaction_Contact |