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

Content:
00E-mail
11Note
22Incoming
32Outgoing
43Please Call Back
53Will Call Back
63Returned Your Call
74Created
84File Uploaded
94File Deleted
104Waiting for Files
114Ready for Download
124Email Notification Sent
134File Downloaded
144File Signed
154File Rejected
164Completed
174Expired
184Canceled
194All Files Purged
Columns
NameTypeConstraintsDescription
interaction_subtype_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.
interaction_type_KEYintNOT NULLThe granular interaction type that this subtype applies to.
descriptionnvarchar (250)NOT NULLDescription (unique per interaction_type_KEY).
Primary key
NameColumnsDescription
PK_Interaction_Subtype$interaction_subtype_KEYinteraction_subtype_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Interaction_Subtype$interaction_type_KEY$descriptioninteraction_type_KEY, description
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Interaction__Interaction_Subtype__interaction_subtype_KEYinteraction_subtype_KEYInteraction

Schema diagram