Table workflow.dbo.Node Generated by
SchemaSpy
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
Node_Name varchar 45
Transition.From_Node_Name From_Node_FK
Transition.To_Node_Name To_Node_FK
Process_Name varchar 45
Transition.From_Process_Name From_Node_FK
Transition.To_Process_Name To_Node_FK
Object.Object_Name Node_Object_FK
Process.Process_Name Node_Process_FK
Object_Name varchar 45
Transition.From_Object_Name From_Node_FK
Transition.To_Object_Name To_Node_FK
Object.Process_Name Node_Object_FK
Error_Handler_Node_Name varchar 45  √  null
Executor_Name varchar 255
Node_Type int 4
Node_Status int 4
Node_Action text 2147483647  √  null
Node_Description varchar 25  √  null
Node_ExStTime datetime 16,3  √  null
Node_AcStTime datetime 16,3  √  null
Node_ExDuration int 4  √  null
Node_AcDuration int 4  √  null

Table contained 0 rows at Thu Dec 07 13:10 CET 2006

Indexes:
Column(s) Type Sort Constraint Name
Node_Name + Object_Name + Process_Name Primary key Asc/Asc/Asc Node_PK
Node_Name + Process_Name + Object_Name Performance Asc/Asc/Asc Node_IDX

Close relationships  within one two degrees of separation :