BBWORKFLOWLOG

Log table used to trace workflow instances

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

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)	yes	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(3000)		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)	yes	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 Keys

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

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BBWORKFLOWLOG_BBWORKFLOWINSTANCEINFOID	BBWORKFLOWINSTANCEINFOID
IX_BBWORKFLOWLOG_LOGDATE	LOGDATE
PK_BBWORKFLOWLOG	ID	yes	yes	yes