Table nbpm.nbpm_node

 Generated by
SchemaSpy
Related columns Constraint names Legend
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents
ID bigint 20 0
nbpm_field STATE FKDC96355068AC491
nbpm_flow NODE FKB48905F833AE02
nbpm_processblock ENDSTATE FKB1DE4866309C76
nbpm_processblock FORK FKB1DE48300CC2
nbpm_processblock JOIN_ FKB1DE48609C875
nbpm_processblock STARTSTATE FKB1DE48A1927D4F
nbpm_transition FROM_ FK4FF269F5D2DDF5
nbpm_transition TO_ FK4FF269F1C144
SUBCLASS varchar 255
PROCESSBLOCK bigint 20  √  null
nbpm_processblock ID FKB48CB2CC7534635E
NAME varchar 255  √  null
DESCRIPTION varchar 255  √  null
PROCESSDEFINITION bigint 20  √  null
nbpm_processblock ID FKB48CB2CCB7C43122
COORDINATEX1 int 11  √  null
COORDINATEY1 int 11  √  null
COORDINATEX2 int 11  √  null
COORDINATEY2 int 11  √  null
ASSIGNMENTDELEGATION bigint 20  √  null
nbpm_delegation ID FKB48CB2CCBDC5B3D5
ACTORROLENAME varchar 255  √  null
SUBPROCESS bigint 20  √  null
nbpm_processblock ID FKB48CB2CC953D700F
PROCESSINVOKERDELEGATION bigint 20  √  null
nbpm_delegation ID FKB48CB2CCAA96D113
ACTOREXPRESSION varchar 255  √  null
DECISIONDELEGATION bigint 20  √  null
nbpm_delegation ID FKB48CB2CC16B99624
FORKDELEGATION bigint 20  √  null
nbpm_delegation ID FKB48CB2CCDB870B8A
JOINDELEGATION bigint 20  √  null
nbpm_delegation ID FKB48CB2CCDC6D79F2

Table contained 13 rows at Sa Mrz 04 15:06 CET 2006

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
DECISIONDELEGATION Performance Asc FKB48CB2CC16B99624
PROCESSBLOCK Performance Asc FKB48CB2CC7534635E
SUBPROCESS Performance Asc FKB48CB2CC953D700F
PROCESSINVOKERDELEGATION Performance Asc FKB48CB2CCAA96D113
PROCESSDEFINITION Performance Asc FKB48CB2CCB7C43122
ASSIGNMENTDELEGATION Performance Asc FKB48CB2CCBDC5B3D5
FORKDELEGATION Performance Asc FKB48CB2CCDB870B8A
JOINDELEGATION Performance Asc FKB48CB2CCDC6D79F2

Close relationships  within one two degrees of separation :