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:
1 | <Project>
2 | <ProjectTask>
3 | <ToDo>
4 | <ScheduledBenefit>
5 | <ScheduledPhoneCall>
6 | <Meeting>
7 | <CPECourse>
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 |