BBWORKFLOWALERT

Primary Key

Primary Key	Field Type
ID	uniqueidentifier

Fields

Field	Field Type	Null	Notes	Description
SUBJECT	nvarchar(255)		Default = ''
DESCRIPTION	nvarchar(max)		Default = ''
DATEISSUED	datetimeoffset		Default = sysdatetimeoffset()
CATEGORY	nvarchar(50)		Default = ''
CUSTOMIDENTIFIER	nvarchar(100)		Default = ''
SEQUENCEID	int
LOOKUPID	nvarchar(100) (Computed)	yes
DATEADDED	datetime		Default = getdate()
DATECHANGED	datetime		Default = getdate()
TS	timestamp
TSLONG	bigint (Computed)	yes	CONVERT(bigint, TS)

Foreign Keys

Foreign Key	Field Type	Null	Notes	Description
BBWORKFLOWINSTANCEINFOID	uniqueidentifier		BBWORKFLOWINSTANCEINFO.ID
BBWORKFLOWINBOXID	uniqueidentifier		BBWORKFLOWINBOX.ID
ALERTPAGEID	uniqueidentifier	yes	PAGEDEFINITIONCATALOG.ID
BBWORKFLOWBUSINESSACTIVITYID	uniqueidentifier	yes	BBWORKFLOWBUSINESSACTIVITY.ID
ADDEDBYID	uniqueidentifier		CHANGEAGENT.ID
CHANGEDBYID	uniqueidentifier		CHANGEAGENT.ID

Indexes

Index Name	Fields	Unique	Primary	Clustered
IX_BBWORKFLOWALERT_BBWORKFLOWBUSINESSACTIVITYID	BBWORKFLOWBUSINESSACTIVITYID
IX_BBWORKFLOWALERT_BBWORKFLOWINBOXID	BBWORKFLOWINBOXID
IX_BBWORKFLOWALERT_BBWORKFLOWINSTANCEINFOID	BBWORKFLOWINSTANCEINFOID
IX_BBWORKFLOWALERT_DATEADDED	DATEADDED			yes
IX_BBWORKFLOWALERT_DATECHANGED	DATECHANGED
PK_BBWORKFLOWALERT	ID	yes	yes
UC_BBWORKFLOWALERT_LOOKUPID	LOOKUPID	yes

Triggers

Trigger Name	Description
TR_BBWORKFLOWALERT_AUDIT_UPDATE
TR_BBWORKFLOWALERT_AUDIT_DELETE