Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 RECURRENCETYPE smallint   Default = ((0)) Enumeration of recurrence types.
 INTERVAL smallint   Default = ((0)) How often the event recurs. (Every 3rd day, every 5th week, etc.)
 DAYOFWEEK tinyint   Default = 0 Bitwise selection of weekday, Sun=0b1, Sat=0b1000000.
 DAY tinyint   Default = 0 The day of the month on which the event occurs. 1-31.
 WEEK tinyint   Default = 0 The week of the month on which the event occurs. 1-5. 1=First, 4=Fourth, 5=Last.
 MONTH tinyint   Default = 0 Number of month. Jan=1, Dec = 12
 STARTDATE date  
 ENDDATE date
 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.

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

Index Name Field(s) Unique Primary Clustered
 IX_RECURRENCE_DATEADDED DATEADDED    
 IX_RECURRENCE_DATECHANGED DATECHANGED      
 PK_RECURRENCE ID  

Trigger Name Description
 TR_RECURRENCE_AUDIT_UPDATE
 TR_RECURRENCE_AUDIT_DELETE

Referenced by Field
 EMAILSCHEDULE RECURRENCEID

Entity-Relationship diagram of this table