View wf_tracking.dbo.vw_UserEvent

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

Dashed lines show
implied relationships

< n > number of related tables

Please support this project

Column	Type	Size	Nulls	Default
UserEventId	bigint identity	19
WorkflowInstanceInternalId	bigint	19
EventOrder	int	10
ActivityInstanceId	bigint	19
EventDateTime	datetime	23,3
UserDataKey	nvarchar	512	√	null
UserDataTypeId	int	10	√	null
UserData_Str	nvarchar	512	√	null
UserData_Blob	image	2147483647	√	null
UserDataNonSerializable	bit	1
DbEventDateTime	datetime	23,3

View SQL:

CREATE VIEW [dbo].[vw_UserEvent] AS SELECT [UserEventId] ,[WorkflowInstanceInternalId] ,[EventOrder] ,[ActivityInstanceId] ,[EventDateTime] ,[UserDataKey] ,[UserDataTypeId] ,[UserData_Str] ,[UserData_Blob] ,[UserDataNonSerializable] ,[DbEventDateTime] FROM [dbo].[UserEvent]

CREATE VIEW [dbo].[vw_UserEvent]
AS
SELECT [UserEventId]
,[WorkflowInstanceInternalId]
,[EventOrder]
,[ActivityInstanceId]
,[EventDateTime]
,[UserDataKey]
,[UserDataTypeId]
,[UserData_Str]
,[UserData_Blob]
,[UserDataNonSerializable]
,[DbEventDateTime]
FROM [dbo].[UserEvent]