Table: Calendar_Category | |||
Storage for a description and color which is assigned to a schedule entry. | |||
Columns | |||
Name | Type | Constraints | Description |
create__changeset_KEY | int | NOT NULL | |
update__changeset_KEY | int | NOT NULL | |
calendar_category_KEY | int | NOT NULL | Assigned by COMMON_dp_Allocate_Unique_Identifiers. Database assigned primary key for this table. |
description | nvarchar (250) | NOT NULL | User defined description. |
color | int | NOT NULL | The Win32 value of the color. |
Primary key | |||
Name | Columns | Description | |
PK_Calendar_Category$calendar_category_KEY | calendar_category_KEY | CLUSTERED | |
Unique constraints | |||
Name | Columns | Description | |
UK_Calendar_Category$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Schedule_Entry__Calendar_Category__calendar_category_KEY | calendar_category_KEY | Schedule_Entry |