Table: Interaction_Type
SYSTEM TABLE: Defines the types of interactions that can be stored in the Interaction table. Tags: read-only Content:
0 | E-mail
1 | <InteractionNote>
2 | <InteractionPhoneCall>
3 | <InteractionPhoneMessage>
4 | File Transfer
5 | Portal Administration
Columns
Name | Type | Constraints | Description
interaction_type_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 | Description (unique).

Primary key
Name | Columns | Description
PK_Interaction_Type$interaction_type_KEY | interaction_type_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Interaction_Type__description | description | Each description must be unique.

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction_Subtype__Interaction_Type__interaction_type_KEY | interaction_type_KEY | Interaction_Subtype |