Table: Calendar_Category
Storage for a description and color which is assigned to a schedule entry.
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
calendar_category_KEYintNOT NULLAssigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table.
descriptionnvarchar (250)NOT NULLUser defined description.
colorintNOT NULLThe Win32 value of the color.
Primary key
NameColumnsDescription
PK_Calendar_Category$calendar_category_KEYcalendar_category_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Calendar_Category$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Schedule_Entry__Calendar_Category__calendar_category_KEYcalendar_category_KEYSchedule_Entry

Schema diagram