Table nbpm.nbpm_processblock

 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_assemblyfile PROCESSDEFINITION FK44FE944AB7C43122
nbpm_attribute PROCESSDEFINITION FK46521BF2B7C43122
nbpm_attribute SCOPE FK46521BF26833E54
nbpm_delegation PROCESSDEFINITION FKBE986672B7C43122
nbpm_job PROCESSDEFINITION FK375F5193B7C43122
nbpm_node PROCESSBLOCK FKB48CB2CC7534635E
nbpm_node PROCESSDEFINITION FKB48CB2CCB7C43122
nbpm_node SUBPROCESS FKB48CB2CC953D700F
nbpm_processblock PARENTBLOCK FKB1DE483AE6A603
nbpm_processblock PROCESSDEFINITION FKB1DE48B7C43122
nbpm_processinstance PROCESSDEFINITION FK236E60DAB7C43122
nbpm_transition PROCESSDEFINITION FK4FF269FB7C43122
SUBCLASS varchar 255
PARENTBLOCK bigint 20  √  null
nbpm_processblock ID FKB1DE483AE6A603
NAME varchar 255  √  null
DESCRIPTION varchar 255  √  null
PROCESSDEFINITION bigint 20  √  null
nbpm_processblock ID FKB1DE48B7C43122
FORK bigint 20  √  null
nbpm_node ID FKB1DE48300CC2
JOIN_ bigint 20  √  null
nbpm_node ID FKB1DE48609C875
RESPONSIBLEUSERNAME varchar 255  √  null
VERSION_ int 11  √  null
STARTSTATE bigint 20  √  null
nbpm_node ID FKB1DE48A1927D4F
ENDSTATE bigint 20  √  null
nbpm_node ID FKB1DE4866309C76
IMAGE mediumblob 16277215  √  null
IMAGEMIMETYPE varchar 255  √  null
IMAGEHEIGHT int 11  √  null
IMAGEWIDTH int 11  √  null
AUTHORIZATIONDELEGATION bigint 20  √  null
nbpm_delegation ID FKB1DE48450E681

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

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PRIMARY
FORK Performance Asc FKB1DE48300CC2
PARENTBLOCK Performance Asc FKB1DE483AE6A603
AUTHORIZATIONDELEGATION Performance Asc FKB1DE48450E681
JOIN_ Performance Asc FKB1DE48609C875
ENDSTATE Performance Asc FKB1DE4866309C76
STARTSTATE Performance Asc FKB1DE48A1927D4F
PROCESSDEFINITION Performance Asc FKB1DE48B7C43122

Close relationships  within one two degrees of separation :