Table: Schedule_Item_Type | |||||||||||||||||
Stores what type of object a [Schedule_Item] record is. [Schedule_Item] records are the base type of other objects like Projects and Tasks. Tags: read-only Content:
| |||||||||||||||||
Columns | |||||||||||||||||
Name | Type | Constraints | Description | ||||||||||||||
schedule_item_type_KEY | int | NOT NULL | 1=Project 2=Task 3=To Do 4=Scheduled Benefit 5=Scheduled Interaction 6=Meeting | ||||||||||||||
description | nvarchar (30) | NOT NULL | System defined description. |
Primary key | |||
Name | Columns | Description | |
PK_Schedule_Item_Type$schedule_item_type_KEY | schedule_item_type_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Schedule_Item_Type__description | description | Each description must be unique. |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Schedule_Item__Schedule_Item_Type__schedule_item_type_KEY | schedule_item_type_KEY | Schedule_Item |