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
NameTypeConstraintsDescription
schedule_item_type_KEYintNOT NULL1=Project
2=Task
3=To Do
4=Scheduled Benefit
5=Scheduled Interaction
6=Meeting
descriptionnvarchar (30)NOT NULLSystem defined description.
Primary key
NameColumnsDescription
PK_Schedule_Item_Type$schedule_item_type_KEYschedule_item_type_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Schedule_Item_Type__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Schedule_Item__Schedule_Item_Type__schedule_item_type_KEYschedule_item_type_KEYSchedule_Item

Schema diagram