Table: Interaction_Type | |||||||||||||||
SYSTEM TABLE: Defines the types of interactions that can be stored in the Interaction table. Tags: read-only Content:
| |||||||||||||||
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 |