Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 CONFLICTDESCRIPTION nvarchar(500)   Default = '' The decsription of the conflict.
 NAME nvarchar(100)   Default = '' Name of the event
 DESCRIPTION nvarchar(255)   Default = '' Description of the event
 CAPACITY int   Default = 0 The capacity for the event.
 STARTTIME UDT_HOURMINUTE   Default = '' The start time of the event.
 ENDTIME UDT_HOURMINUTE   Default = '' The end time of the event.
 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.
 SCHEDULEID uniqueidentifier Uniquely identifies the scheduling run
 STARTDATE date   The start date of the event.
 ENDDATE date   The end date of the event.
 STARTDATETIME datetime (Computed) dateadd(minute, convert(tinyint, substring(STARTTIME, 3, 2)), dateadd(hour, convert(tinyint, substring(STARTTIME, 1, 2)), convert(datetime, STARTDATE)))
 ENDDATETIME datetime (Computed) dateadd(minute, convert(tinyint, substring(ENDTIME, 3, 2)), dateadd(hour, convert(tinyint, substring(ENDTIME, 1, 2)), convert(datetime, ENDDATE)))
 PUBLICDESCRIPTIONTEXT nvarchar(max)   Default = ''
 PUBLICDESCRIPTIONHTML nvarchar(max)   Default = ''
 SUPERCEDESPROGRAMPUBLICDESCRIPTION bit   Default = 0

Foreign Key Field Type Null Notes Description
 PROGRAMID uniqueidentifier   PROGRAM.ID FK to PROGRAM
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_EVENTCONFLICT_DATEADDED DATEADDED    
 IX_EVENTCONFLICT_DATECHANGED DATECHANGED      
 IX_EVENTCONFLICT_PROGRAMID PROGRAMID      
 PK_EVENTCONFLICT ID  

Trigger Name Description
 TR_EVENTCONFLICT_AUDIT_UPDATE
 TR_EVENTCONFLICT_AUDIT_DELETE

Referenced by Field
 EVENTRESOURCE EVENTCONFLICTID
 EVENTSTAFFRESOURCE EVENTCONFLICTID
 PREFERENCEGROUPCONFLICT EVENTCONFLICTID
 PROGRAMEVENTLOCATION EVENTCONFLICTID

Entity-Relationship diagram of this table