CALENDARDATALISTCOLOR
Contains the meta information for color selection by calendar specs.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| COLORSTYLECODE |
tinyint |
|
Default = 0 |
The color style to use for the calendar data list. |
| COLORSTYLE |
nvarchar(13) (Computed) |
yes |
CASE [COLORSTYLECODE] WHEN 0 THEN N'Yellow' WHEN 1 THEN N'Coral' WHEN 2 THEN N'Lilac' WHEN 3 THEN N'Periwinkle' WHEN 4 THEN N'Turquoise' WHEN 5 THEN N'Sea Green' WHEN 6 THEN N'Khaki' WHEN 7 THEN N'Yellow-Orange' WHEN 8 THEN N'Mauve' WHEN 9 THEN N'Blue' WHEN 10 THEN N'Tan' WHEN 11 THEN N'Violet' WHEN 12 THEN N'Purple' WHEN 13 THEN N'Royal Blue' WHEN 14 THEN N'Blue-Green' WHEN 15 THEN N'Green' WHEN 16 THEN N'Orange' WHEN 17 THEN N'Red' WHEN 18 THEN N'Olive' WHEN 19 THEN N'Brown' END |
Provides a translation for the 'COLORSTYLECODE' field. |
| DATEADDED |
datetime |
|
Default = getdate() |
Indicates the date this record was added. |
| DATECHANGED |
datetime |
|
Default = getdate() |
Indicates the date this record was last changed. |
| TS |
timestamp |
|
|
Timestamp. |
| TSLONG |
bigint (Computed) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
Foreign Keys
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_CALENDARDATALISTCOLOR_DATEADDED |
DATEADDED |
|
|
yes |
| IX_CALENDARDATALISTCOLOR_DATECHANGED |
DATECHANGED |
|
|
|
| PK_CALENDARDATALISTCOLOR |
ID |
yes |
yes |
|
| UIX_CALENDARDATALISTCOLOR_CALENDARCATALOGID_DATALISTID |
CALENDARCATALOGID, DATALISTID |
yes |
|
|
Triggers