View wf_tracking.dbo.vw_ActivityInstance

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

Auto

Default

Children

Parents

Comments

WorkflowInstanceInternalId

bigint

ActivityInstanceId

bigint identity

ActivityInstance.ActivityInstanceId

Implied Constraint

QualifiedName

nvarchar

128

ContextGuid

uniqueidentifier

ParentContextGuid

uniqueidentifier

√

null

WorkflowInstanceEventId

bigint

√

null

View SQL:

CREATE VIEW [dbo].[vw_ActivityInstance] AS SELECT [WorkflowInstanceInternalId] ,[ActivityInstanceId] ,[QualifiedName] ,[ContextGuid] ,[ParentContextGuid] ,[WorkflowInstanceEventId] FROM [dbo].[ActivityInstance]

CREATE VIEW [dbo].[vw_ActivityInstance]
AS
SELECT [WorkflowInstanceInternalId]
,[ActivityInstanceId]
,[QualifiedName]
,[ContextGuid]
,[ParentContextGuid]
,[WorkflowInstanceEventId]
FROM [dbo].[ActivityInstance]