Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 BUSINESSPROCESSPARAMETERSETID uniqueidentifier
 DATEADDED datetime   Default = getdate()
 DATECHANGED datetime   Default = getdate()
 TS timestamp  
 TSLONG bigint (Computed) CONVERT(bigint, TS)

Foreign Key Field Type Null Notes Description
 BUSINESSPROCESSID uniqueidentifier   BUSINESSPROCESSCATALOG.ID
 SCHEDULEID uniqueidentifier   SCHEDULE.ID
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID

Index Name Field(s) Unique Primary Clustered
 IX_BUSINESSPROCESSSCHEDULE_DATEADDED DATEADDED    
 IX_BUSINESSPROCESSSCHEDULE_DATECHANGED DATECHANGED      
 PK_BUSINESSPROCESSSCHEDULE ID  

Trigger Name Description
 TR_BUSINESSPROCESSSCHEDULE_AUDIT_UPDATE
 TR_BUSINESSPROCESSSCHEDULE_AUDIT_DELETE

Entity-Relationship diagram of this table