Table: Interaction_Type
SYSTEM TABLE: Defines the types of interactions that can be stored in the Interaction table.
Tags: read-only

Content:
0E-mail
1<InteractionNote>
2<InteractionPhoneCall>
3<InteractionPhoneMessage>
4File Transfer
5Portal Administration
Columns
NameTypeConstraintsDescription
interaction_type_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 (30)NOT NULLDescription (unique).
Primary key
NameColumnsDescription
PK_Interaction_Type$interaction_type_KEYinteraction_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Interaction_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction_Subtype__Interaction_Type__interaction_type_KEYinteraction_type_KEYInteraction_Subtype

Schema diagram