Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 LOGDATE datetimeoffset   Default = sysdatetimeoffset() Time that this log record was created on the SQL Server.
 LOGTYPECODE tinyint   Default = 0 Indicates the type of log record (info, warning, or error).
 LOGTYPE nvarchar(11) (Computed) CASE [LOGTYPECODE] WHEN 0 THEN N'Information' WHEN 1 THEN N'Warning' WHEN 2 THEN N'Error' END Provides a translation for the 'LOGTYPECODE' field.
 LOGMESSAGE nvarchar(2048)   Default = '' The text of the message that has been logged.
 DATEADDED datetime   Default = getdate()
 SOURCECODE tinyint   Default = 0 Indicates the source of his log record (app server, workflow server, activity, or other).
 SOURCE nvarchar(17) (Computed) CASE [SOURCECODE] WHEN 0 THEN N'Other' WHEN 1 THEN N'AppFx Service' WHEN 2 THEN N'Workflow Service' WHEN 3 THEN N'Workflow Activity' WHEN 4 THEN N'Workflow Queue' END Provides a translation for the 'SOURCECODE' field.

Foreign Key Field Type Null Notes Description
 BBWORKFLOWINSTANCEINFOID uniqueidentifier BBWORKFLOWINSTANCEINFO.ID The BBWORKFLOWINSTANCEINFO workflow instance record that this log is for.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT

Index Name Field(s) Unique Primary Clustered
 IX_BBWORKFLOWLOG_BBWORKFLOWINSTANCEINFOID BBWORKFLOWINSTANCEINFOID      
 IX_BBWORKFLOWLOG_LOGDATE LOGDATE      
 PK_BBWORKFLOWLOG ID

Entity-Relationship diagram of this table