Table: Priority | ||||||||||||
Tags: read-only Content:
| ||||||||||||
Columns | ||||||||||||
Name | Type | Constraints | Description | |||||||||
priority_KEY | int | NOT NULL | Primary key for this table. | |||||||||
sort | int | NOT NULL | User defined sort for this table. | |||||||||
description | nvarchar (250) | NOT NULL | User defined description (unique). |
Primary key | |||
Name | Columns | Description | |
PK_Priority$priority_KEY | priority_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Priority$description | description | Each description must be unique. |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Project_Template__Priority__priority_KEY | priority_KEY | Project_Template | |
FK_Interaction__Priority__priority_KEY | priority_KEY | Interaction | |
FK_Schedule_Item__Priority__priority_KEY | priority_KEY | Schedule_Item |