SchemaSpy Analysis of wf_tracking.dbo - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Wed Oct 25 17:49 CEST 2006
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
wf_tracking.dbo contains 218 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
ActivityExecutionStatusEventId ActivityExecutionStatusEvent bigint identity 19  √ 
ActivityExecutionStatusEventId vw_ActivityExecutionStatusEvent bigint identity 19
ActivityInstanceId ActivityExecutionStatusEvent bigint 19
ActivityInstanceId ActivityInstance bigint identity 19  √ 
vw_ActivityInstance.ActivityInstanceId Implied Constraint
ActivityInstanceId UserEvent bigint 19
ActivityInstanceId vw_ActivityExecutionStatusEvent bigint 19
ActivityInstanceId vw_ActivityInstance bigint identity 19
ActivityInstance.ActivityInstanceId Implied Constraint
ActivityInstanceId vw_UserEvent bigint 19
ActivityTypeId Activity int 10
ActivityTypeId AddedActivity int 10
ActivityTypeId vw_Activity int 10
ActivityTypeId vw_AddedActivity int 10
AddedActivityAction AddedActivity nvarchar 2000  √  null
AddedActivityAction vw_AddedActivity nvarchar 2000  √  null
Annotation EventAnnotation nvarchar 1024  √  null
Annotation TrackingDataItemAnnotation nvarchar 1024
Annotation vw_EventAnnotation nvarchar 1024  √  null
Annotation vw_TrackingDataItemAnnotation nvarchar 1024
AssemblyFullName Type nvarchar 256
AssemblyFullName vw_Type nvarchar 256
CallPath WorkflowInstance nvarchar 400  √  null
CallPath vw_WorkflowInstance nvarchar 400  √  null
CallerContextGuid WorkflowInstance uniqueidentifier 36  √  null
CallerContextGuid vw_WorkflowInstance uniqueidentifier 36  √  null
CallerInstanceId WorkflowInstance uniqueidentifier 36  √  null
CallerInstanceId vw_WorkflowInstance uniqueidentifier 36  √  null
CallerParentContextGuid WorkflowInstance uniqueidentifier 36  √  null
CallerParentContextGuid vw_WorkflowInstance uniqueidentifier 36  √  null
ContextGuid ActivityInstance uniqueidentifier 36
ContextGuid WorkflowInstance uniqueidentifier 36
ContextGuid vw_ActivityInstance uniqueidentifier 36
ContextGuid vw_WorkflowInstance uniqueidentifier 36
CreatedDateTime TrackingPartitionSetName datetime 23,3 (getutcdate())
CreatedDateTime vw_TrackingPartitionSetName datetime 23,3
DataNonSerializable TrackingDataItem bit 1
DataNonSerializable vw_TrackingDataItem bit 1
Data_Blob TrackingDataItem image 2147483647  √  null
Data_Blob vw_TrackingDataItem image 2147483647  √  null
Data_Str TrackingDataItem nvarchar 512  √  null
Data_Str vw_TrackingDataItem nvarchar 512  √  null
DbEndDateTime WorkflowInstance datetime 23,3  √  null
DbEndDateTime vw_WorkflowInstance datetime 23,3  √  null
DbEventDateTime ActivityExecutionStatusEvent datetime 23,3 (getutcdate())
DbEventDateTime UserEvent datetime 23,3 (getutcdate())
DbEventDateTime WorkflowInstanceEvent datetime 23,3 (getutcdate())
DbEventDateTime vw_ActivityExecutionStatusEvent datetime 23,3
DbEventDateTime vw_UserEvent datetime 23,3
DbEventDateTime vw_WorkflowInstanceEvent datetime 23,3
DbInitializedDateTime WorkflowInstance datetime 23,3 (getutcdate())
DbInitializedDateTime vw_WorkflowInstance datetime 23,3
Description ActivityExecutionStatus nvarchar 128  √  null
Description TrackingWorkflowEvent nvarchar 32
Description vw_ActivityExecutionStatus nvarchar 128  √  null
Description vw_TrackingWorkflowEvent nvarchar 32
EndDateTime TrackingPartitionSetName datetime 23,3  √  null
EndDateTime WorkflowInstance datetime 23,3  √  null
EndDateTime vw_TrackingPartitionSetName datetime 23,3  √  null
EndDateTime vw_WorkflowInstance datetime 23,3  √  null
EventArg WorkflowInstanceEvent image 2147483647  √  null
EventArg vw_WorkflowInstanceEvent image 2147483647  √  null
EventArgTypeId WorkflowInstanceEvent int 10  √  null
EventArgTypeId vw_WorkflowInstanceEvent int 10  √  null
EventDateTime ActivityExecutionStatusEvent datetime 23,3
EventDateTime UserEvent datetime 23,3
EventDateTime WorkflowInstanceEvent datetime 23,3
EventDateTime vw_ActivityExecutionStatusEvent datetime 23,3
EventDateTime vw_UserEvent datetime 23,3
EventDateTime vw_WorkflowInstanceEvent datetime 23,3
EventId EventAnnotation bigint 19
EventId TrackingDataItem bigint 19
EventId vw_EventAnnotation bigint 19
EventId vw_TrackingDataItem bigint 19
EventOrder ActivityExecutionStatusEvent int 10
EventOrder UserEvent int 10
EventOrder WorkflowInstanceEvent int 10
EventOrder vw_ActivityExecutionStatusEvent int 10
EventOrder vw_UserEvent int 10
EventOrder vw_WorkflowInstanceEvent int 10
EventTypeId EventAnnotation char 1
EventTypeId TrackingDataItem char 1
EventTypeId vw_EventAnnotation char 1
EventTypeId vw_TrackingDataItem char 1
ExecutionStatusId ActivityExecutionStatus tinyint 3
ExecutionStatusId ActivityExecutionStatusEvent tinyint 3
ExecutionStatusId vw_ActivityExecutionStatus tinyint 3
ExecutionStatusId vw_ActivityExecutionStatusEvent tinyint 3
FieldName TrackingDataItem nvarchar 256
FieldName vw_TrackingDataItem nvarchar 256
FieldTypeId TrackingDataItem int 10  √  null
FieldTypeId vw_TrackingDataItem int 10  √  null
InitializedDateTime WorkflowInstance datetime 23,3
InitializedDateTime vw_WorkflowInstance datetime 23,3
InsertDateTime DefaultTrackingProfile datetime 23,3 (getutcdate())
InsertDateTime TrackingProfile datetime 23,3 (getutcdate())
InsertDateTime vw_DefaultTrackingProfile datetime 23,3
InsertDateTime vw_TrackingProfile datetime 23,3
InstanceId TrackingProfileInstance uniqueidentifier 36
vw_TrackingProfileInstance.InstanceId Implied Constraint
InstanceId vw_TrackingProfileInstance uniqueidentifier 36
TrackingProfileInstance.InstanceId Implied Constraint
Interval TrackingPartitionInterval char 1  √  null
Interval vw_TrackingPartitionInterval char 1  √  null
IsInstanceType Type bit 1
IsInstanceType vw_Type bit 1
Name TrackingPartitionSetName varchar 32
Name vw_TrackingPartitionSetName varchar 32
Order AddedActivity int 10  √  null
Order RemovedActivity int 10  √  null
Order vw_AddedActivity int 10  √  null
Order vw_RemovedActivity int 10  √  null
ParentContextGuid ActivityInstance uniqueidentifier 36  √  null
ParentContextGuid vw_ActivityInstance uniqueidentifier 36  √  null
ParentQualifiedName Activity nvarchar 128  √  null
ParentQualifiedName AddedActivity nvarchar 128  √  null
ParentQualifiedName RemovedActivity nvarchar 128  √  null
ParentQualifiedName vw_Activity nvarchar 128  √  null
ParentQualifiedName vw_AddedActivity nvarchar 128  √  null
ParentQualifiedName vw_RemovedActivity nvarchar 128  √  null
PartitionId TrackingPartitionSetName int identity 10  √ 
PartitionId vw_TrackingPartitionSetName int identity 10
PartitionInterval TrackingPartitionSetName char 1
PartitionInterval vw_TrackingPartitionSetName char 1
QualifiedName Activity nvarchar 128
QualifiedName ActivityInstance nvarchar 128
QualifiedName AddedActivity nvarchar 128
QualifiedName RemovedActivity nvarchar 128
QualifiedName vw_Activity nvarchar 128
QualifiedName vw_ActivityInstance nvarchar 128
QualifiedName vw_AddedActivity nvarchar 128
QualifiedName vw_RemovedActivity nvarchar 128
RemovedActivityAction RemovedActivity nvarchar 2000  √  null
RemovedActivityAction vw_RemovedActivity nvarchar 2000  √  null
TrackingDataItemId TrackingDataItem bigint identity 19  √ 
vw_TrackingDataItem.TrackingDataItemId Implied Constraint
TrackingDataItemId TrackingDataItemAnnotation bigint 19
TrackingDataItemId vw_TrackingDataItem bigint identity 19
TrackingDataItem.TrackingDataItemId Implied Constraint
TrackingDataItemId vw_TrackingDataItemAnnotation bigint 19
TrackingProfileId TrackingProfile int identity 10  √ 
TrackingProfileId vw_TrackingProfile int identity 10
TrackingProfileXml DefaultTrackingProfile ntext 1073741823
TrackingProfileXml TrackingProfile ntext 1073741823  √  null
TrackingProfileXml TrackingProfileInstance ntext 1073741823  √  null
TrackingProfileXml vw_DefaultTrackingProfile ntext 1073741823
TrackingProfileXml vw_TrackingProfile ntext 1073741823  √  null
TrackingProfileXml vw_TrackingProfileInstance ntext 1073741823  √  null
TrackingWorkflowEventId TrackingWorkflowEvent tinyint 3
WorkflowInstanceEvent.TrackingWorkflowEventId Implied Constraint
vw_TrackingWorkflowEvent.TrackingWorkflowEventId Implied Constraint
vw_WorkflowInstanceEvent.TrackingWorkflowEventId Implied Constraint
TrackingWorkflowEventId WorkflowInstanceEvent tinyint 3
TrackingWorkflowEvent.TrackingWorkflowEventId Implied Constraint
TrackingWorkflowEventId vw_TrackingWorkflowEvent tinyint 3
TrackingWorkflowEvent.TrackingWorkflowEventId Implied Constraint
TrackingWorkflowEventId vw_WorkflowInstanceEvent tinyint 3
TrackingWorkflowEvent.TrackingWorkflowEventId Implied Constraint
TypeFullName Type nvarchar 128
TypeFullName vw_Type nvarchar 128
TypeId Type int identity 10  √ 
TrackingProfile.WorkflowTypeId fk_TrackingProfile_WorkflowTypeId
Workflow.WorkflowTypeId fk_Workflow_WorkflowTypeId_Type_TypeId
vw_Type.TypeId Implied Constraint
TypeId vw_Type int identity 10
Type.TypeId Implied Constraint
UpdatedDateTime TrackingProfileInstance datetime 23,3 (getutcdate())
UpdatedDateTime vw_TrackingProfileInstance datetime 23,3
UserDataKey UserEvent nvarchar 512  √  null
UserDataKey vw_UserEvent nvarchar 512  √  null
UserDataNonSerializable UserEvent bit 1
UserDataNonSerializable vw_UserEvent bit 1
UserDataTypeId UserEvent int 10  √  null
UserDataTypeId vw_UserEvent int 10  √  null
UserData_Blob UserEvent image 2147483647  √  null
UserData_Blob vw_UserEvent image 2147483647  √  null
UserData_Str UserEvent nvarchar 512  √  null
UserData_Str vw_UserEvent nvarchar 512  √  null
UserEventId UserEvent bigint identity 19  √ 
UserEventId vw_UserEvent bigint identity 19
Version DefaultTrackingProfile varchar 32
TrackingProfile.Version Implied Constraint
vw_DefaultTrackingProfile.Version Implied Constraint
vw_TrackingProfile.Version Implied Constraint
Version TrackingProfile varchar 32
DefaultTrackingProfile.Version Implied Constraint
Version vw_DefaultTrackingProfile varchar 32
DefaultTrackingProfile.Version Implied Constraint
Version vw_TrackingProfile varchar 32
DefaultTrackingProfile.Version Implied Constraint
WorkflowDefinition Workflow ntext 1073741823  √  null
WorkflowDefinition vw_Workflow ntext 1073741823  √  null
WorkflowInstanceEventId ActivityInstance bigint 19  √  null
WorkflowInstanceEventId AddedActivity bigint 19
WorkflowInstanceEventId RemovedActivity bigint 19
WorkflowInstanceEventId WorkflowInstanceEvent bigint identity 19  √ 
vw_WorkflowInstanceEvent.WorkflowInstanceEventId Implied Constraint
WorkflowInstanceEventId vw_ActivityInstance bigint 19  √  null
WorkflowInstanceEventId vw_AddedActivity bigint 19
WorkflowInstanceEventId vw_RemovedActivity bigint 19
WorkflowInstanceEventId vw_WorkflowInstanceEvent bigint identity 19
WorkflowInstanceEvent.WorkflowInstanceEventId Implied Constraint
WorkflowInstanceId WorkflowInstance uniqueidentifier 36
WorkflowInstanceId vw_WorkflowInstance uniqueidentifier 36
WorkflowInstanceInternalId ActivityExecutionStatusEvent bigint 19
WorkflowInstanceInternalId ActivityInstance bigint 19
WorkflowInstanceInternalId AddedActivity bigint 19
WorkflowInstanceInternalId EventAnnotation bigint 19
WorkflowInstanceInternalId RemovedActivity bigint 19
WorkflowInstanceInternalId TrackingDataItem bigint 19
WorkflowInstanceInternalId TrackingDataItemAnnotation bigint 19
WorkflowInstanceInternalId UserEvent bigint 19
WorkflowInstanceInternalId WorkflowInstance bigint identity 19  √ 
vw_WorkflowInstance.WorkflowInstanceInternalId Implied Constraint
WorkflowInstanceInternalId WorkflowInstanceEvent bigint 19
WorkflowInstanceInternalId vw_ActivityExecutionStatusEvent bigint 19
WorkflowInstanceInternalId vw_ActivityInstance bigint 19
WorkflowInstanceInternalId vw_AddedActivity bigint 19
WorkflowInstanceInternalId vw_EventAnnotation bigint 19
WorkflowInstanceInternalId vw_RemovedActivity bigint 19
WorkflowInstanceInternalId vw_TrackingDataItem bigint 19
WorkflowInstanceInternalId vw_TrackingDataItemAnnotation bigint 19
WorkflowInstanceInternalId vw_UserEvent bigint 19
WorkflowInstanceInternalId vw_WorkflowInstance bigint identity 19
WorkflowInstance.WorkflowInstanceInternalId Implied Constraint
WorkflowInstanceInternalId vw_WorkflowInstanceEvent bigint 19
WorkflowTypeId Activity int 10
Workflow.WorkflowTypeId fk_Workflow_WorkflowTypeId
WorkflowTypeId TrackingProfile int 10
Type.TypeId fk_TrackingProfile_WorkflowTypeId
WorkflowTypeId Workflow int 10
Activity.WorkflowTypeId fk_Workflow_WorkflowTypeId
Type.TypeId fk_Workflow_WorkflowTypeId_Type_TypeId
WorkflowTypeId WorkflowInstance int 10
WorkflowTypeId vw_Activity int 10
WorkflowTypeId vw_TrackingProfile int 10
WorkflowTypeId vw_Workflow int 10
WorkflowTypeId vw_WorkflowInstance int 10
actions sysconstraints int 10  √  null
colid sysconstraints smallint 5  √  null
constid sysconstraints int 10  √  null
error sysconstraints int 10  √  null
id sysconstraints int 10  √  null
name syssegments varchar 10
segment syssegments int 10
spare1 sysconstraints tinyint 3  √  null
status sysconstraints int 10  √  null
status syssegments int 10