Table: Interaction_Subtype
SYSTEM TABLE: Defines the subtypes of interactions that can be stored in the Interaction table. Tags: read-only Content:
0 | 0 | E-mail
1 | 1 | Note
2 | 2 | Incoming
3 | 2 | Outgoing
4 | 3 | Please Call Back
5 | 3 | Will Call Back
6 | 3 | Returned Your Call
7 | 4 | Created
8 | 4 | File Uploaded
9 | 4 | File Deleted
10 | 4 | Waiting for Files
11 | 4 | Ready for Download
12 | 4 | Email Notification Sent
13 | 4 | File Downloaded
14 | 4 | File Signed
15 | 4 | File Rejected
16 | 4 | Completed
17 | 4 | Expired
18 | 4 | Canceled
19 | 4 | All Files Purged
Columns
Name | Type | Constraints | Description
interaction_subtype_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.
interaction_type_KEY | int | NOT NULL | The granular interaction type that this subtype applies to.
description | nvarchar (250) | NOT NULL | Description (unique per interaction_type_KEY).

Primary key
Name | Columns | Description
PK_Interaction_Subtype$interaction_subtype_KEY | interaction_subtype_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Interaction_Subtype$interaction_type_KEY$description | interaction_type_KEY, description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Interaction__Interaction_Subtype__interaction_subtype_KEY | interaction_subtype_KEY | Interaction |