Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 EVENTTIME datetimeoffset   The time the tracking record occured.
 INSTANCEID uniqueidentifier   The Windows Workflow Foundation instance id for this record.
 TRACELEVELCODE tinyint   Default = 0 The System.Diagnostics.TraceLevel of the event.
 TRACELEVEL nvarchar(7) (Computed) CASE [TRACELEVELCODE] WHEN 0 THEN N'Off' WHEN 1 THEN N'Error' WHEN 2 THEN N'Warning' WHEN 3 THEN N'Info' WHEN 4 THEN N'Verbose' END Provides a translation for the 'TRACELEVELCODE' field.
 TRACKINGRECORDNUMBER bigint   Default = ((0)) A sequence that defines the order in which tracking records are generated.
 DATEADDED datetime   Default = getdate()
 ACTIVITYDEFINITIONID nvarchar(510)   Default = ''
 WORKFLOWSTATE nvarchar(100)   Default = ''
 REASON nvarchar(1024)   Default = ''

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

Index Name Field(s) Unique Primary Clustered
 IX_BBWORKFLOWINSTANCETRACKING_DATEADDED DATEADDED      
 IX_BBWORKFLOWINSTANCETRACKING_EVENTTIME EVENTTIME      
 IX_BBWORKFLOWINSTANCETRACKING_INSTANCEID INSTANCEID      
 IX_BBWORKFLOWINSTANCETRACKING_TRACKINGRECORDNUMBER TRACKINGRECORDNUMBER      
 PK_BBWORKFLOWINSTANCETRACKING ID

Entity-Relationship diagram of this table