Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 NAME nvarchar(100)   Default = '' The name of the block.
 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) CONVERT(bigint, TS) Numeric representation of the timestamp.
 COLORSTYLECODE tinyint   Default = 0 The color style to use for the calendar when showing the block.
 COLORSTYLE nvarchar(13) (Computed) 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.

Foreign Key Field Type Null Notes Description
 PATTERNID uniqueidentifier   PATTERN.ID The pattern for which this block is defined
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_PATTERNBLOCK_DATEADDED DATEADDED    
 IX_PATTERNBLOCK_DATECHANGED DATECHANGED      
 PK_PATTERNBLOCK ID  
 UIX_PATTERNBLOCK_NAME_PATTERNID NAME, PATTERNID    

Trigger Name Description
 TR_PATTERNBLOCK_AUDIT_UPDATE
 TR_PATTERNBLOCK_AUDIT_DELETE

Referenced by Field
 CLASSMEETINGGROUP PATTERNBLOCKID
 PATTERNBLOCKMEETING PATTERNBLOCKID

Entity-Relationship diagram of this table