Table wf_tracking.dbo.ActivityInstance

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 19
ActivityInstanceId bigint identity 19  √ 
vw_ActivityInstance.ActivityInstanceId Implied Constraint
QualifiedName nvarchar 128
ContextGuid uniqueidentifier 36
ParentContextGuid uniqueidentifier 36  √  null
WorkflowInstanceEventId bigint 19  √  null

Table contained 0 rows at Wed Oct 25 17:49 CEST 2006

Indexes:
Column(s) Type Sort Constraint Name
ActivityInstanceId Primary key Asc pk_ActivityInstance_ActivityInstanceId
WorkflowInstanceInternalId Performance Asc idx_ActivityInstance_WorkflowInstanceInternalId
WorkflowInstanceInternalId + QualifiedName + ContextGuid + ParentContextGuid Performance Asc/Asc/Asc/Asc idx_ActivityInstance_WorkflowInstanceInternalId_QualifiedName_ContextGuid_ParentContextGuid

Close relationships: