Open topic with navigation

BBWORKFLOWLOG (4.0SP20)

Top
Primary Key
Foreign Key Fields
Fields
Indexes

Log table used to trace workflow instances

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

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

Fields
Field	Field Type	Null	Notes	Description
LOGDATE	datetimeoffset	false	sysdatetimeoffset()	Time that this log record was created on the SQL Server.
LOGTYPECODE	tinyint	false	0	Indicates the type of log record (info, warning, or error).
LOGTYPE	nvarchar(11) (Computed)	true		Provides a translation for the 'LOGTYPECODE' field.
LOGMESSAGE	nvarchar(3000)	false	''	The text of the message that has been logged.
DATEADDED	datetime	false	getdate()
SOURCECODE	tinyint	false	0	Indicates the source of his log record (app server, workflow server, activity, or other).
SOURCE	nvarchar(17) (Computed)	true		Provides a translation for the 'SOURCECODE' field.

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