View wf_tracking.dbo.vw_WorkflowInstance

Generated by
SchemaSpy
Implied relationships Related columns Constraint names Comments Legend
Legend: SourceForge.net
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 Auto Default Children Parents Comments
WorkflowInstanceInternalId bigint identity 19
WorkflowInstance.WorkflowInstanceInternalId Implied Constraint
WorkflowInstanceId uniqueidentifier 36
ContextGuid uniqueidentifier 36
CallerInstanceId uniqueidentifier 36  √  null
CallPath nvarchar 400  √  null
CallerContextGuid uniqueidentifier 36  √  null
CallerParentContextGuid uniqueidentifier 36  √  null
WorkflowTypeId int 10
InitializedDateTime datetime 23,3
DbInitializedDateTime datetime 23,3
EndDateTime datetime 23,3  √  null
DbEndDateTime datetime 23,3  √  null
View SQL:




CREATE VIEW [dbo].[vw_WorkflowInstance]
AS
SELECT [WorkflowInstanceInternalId]
,[WorkflowInstanceId]
,[ContextGuid]
,[CallerInstanceId]
,[CallPath]
,[CallerContextGuid]
,[CallerParentContextGuid]
,[WorkflowTypeId]
,[InitializedDateTime]
,[DbInitializedDateTime]
,[EndDateTime]
,[DbEndDateTime]
FROM [dbo].[WorkflowInstance]

Close relationships: