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 |
|
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). |