SchemaSpy Analysis of nbpm - Columns

 Generated by
SchemaSpy
Generated by SchemaSpy on Sa Mrz 04 15:06 CET 2006
Legend:
Primary key columns
Columns with indexes

Related columns Constraint names Legend
nbpm contains 126 columns:
Column Table Type Size Nulls Auto Default Children Parents
ACCESS_ nbpm_field smallint 6  √  null
ACTIONDELEGATION nbpm_action bigint 20  √  null
nbpm_delegation ID FKAD5A74807E4E3BFE
ACTIONDELEGATION nbpm_job bigint 20  √  null
nbpm_delegation ID FK375F51937E4E3BFE
ACTOREXPRESSION nbpm_node varchar 255  √  null
ACTORID nbpm_flow varchar 255  √  null
ACTORID nbpm_log varchar 255  √  null
ACTORROLENAME nbpm_node varchar 255  √  null
ASSEMBLYNAME nbpm_assemblyfile varchar 255  √  null
ASSEMBLYVERSION nbpm_assemblyfile varchar 255  √  null
ASSIGNMENTDELEGATION nbpm_node bigint 20  √  null
nbpm_delegation ID FKB48CB2CCBDC5B3D5
ATTRIBUTE nbpm_attributeinstance bigint 20  √  null
nbpm_attribute ID FK84748E87C7AA9C
ATTRIBUTE nbpm_field bigint 20  √  null
nbpm_attribute ID FKDC963550C7AA9C
ATTRIBUTE nbpm_logdetail bigint 20  √  null
nbpm_attribute ID FKD617A9EBC7AA9C
AUTHORIZATIONDELEGATION nbpm_processblock bigint 20  √  null
nbpm_delegation ID FKB1DE48450E681
BYTES nbpm_assemblyfile mediumblob 16277215  √  null
CLASSNAME nbpm_delegation varchar 255  √  null
CLASSNAME nbpm_logdetail varchar 255  √  null
CONFIGURATION nbpm_delegation varchar 255  √  null
CONTEXT nbpm_job bigint 20  √  null
nbpm_flow ID FK375F519338B735AF
COORDINATEX1 nbpm_node int 11  √  null
COORDINATEX2 nbpm_node int 11  √  null
COORDINATEY1 nbpm_node int 11  √  null
COORDINATEY2 nbpm_node int 11  √  null
DATE_ nbpm_job datetime 19  √  null
DATE_ nbpm_log datetime 19  √  null
DECISIONDELEGATION nbpm_node bigint 20  √  null
nbpm_delegation ID FKB48CB2CC16B99624
DEFINITIONOBJECT nbpm_action bigint 20 0
DELEGATION nbpm_logdetail bigint 20  √  null
nbpm_delegation ID FKD617A9EB52D4AD28
DESCRIPTION nbpm_attribute varchar 255  √  null
DESCRIPTION nbpm_field varchar 255  √  null
DESCRIPTION nbpm_node varchar 255  √  null
DESCRIPTION nbpm_processblock varchar 255  √  null
DESCRIPTION nbpm_transition varchar 255  √  null
EMAIL nbpm_actor varchar 255  √  null
ENDSTATE nbpm_processblock bigint 20  √  null
nbpm_node ID FKB1DE4866309C76
END_ nbpm_flow datetime 19  √  null
END_ nbpm_processinstance datetime 19  √  null
EVENTTYPE nbpm_action smallint 6 0
EXCEPTIONHANDLER nbpm_delegation smallint 6  √  null
EXCEPTIONMESSAGE nbpm_logdetail varchar 255  √  null
FILENAME nbpm_assemblyfile varchar 255  √  null
FIRSTNAME nbpm_actor varchar 255  √  null
FLOW nbpm_log bigint 20  √  null
nbpm_flow ID FK375F591A30012E
FORK nbpm_processblock bigint 20  √  null
nbpm_node ID FKB1DE48300CC2
FORKDELEGATION nbpm_node bigint 20  √  null
nbpm_delegation ID FKB48CB2CCDB870B8A
FROM_ nbpm_transition bigint 20  √  null
nbpm_node ID FK4FF269F5D2DDF5
GROUP_ nbpm_membership varchar 255  √  null
nbpm_actor ID FK1BE14120B63DD9C0
HTMLFORMATTERDELEGATION nbpm_field bigint 20  √  null
nbpm_delegation ID FKDC9635503553D7E7
ID nbpm_action bigint 20 0
ID nbpm_actor varchar 255
nbpm_actor PARENT FKDC4D3E4BC4AB08AA
nbpm_membership GROUP_ FK1BE14120B63DD9C0
nbpm_membership USER_ FK1BE141206A68DF4
ID nbpm_assemblyfile bigint 20 0
ID nbpm_attribute bigint 20 0
nbpm_attributeinstance ATTRIBUTE FK84748E87C7AA9C
nbpm_field ATTRIBUTE FKDC963550C7AA9C
nbpm_logdetail ATTRIBUTE FKD617A9EBC7AA9C
ID nbpm_attributeinstance bigint 20 0
ID nbpm_delegation bigint 20 0
nbpm_action ACTIONDELEGATION FKAD5A74807E4E3BFE
nbpm_attribute SERIALIZERDELEGATION FK46521BF2A061B05A
nbpm_field HTMLFORMATTERDELEGATION FKDC9635503553D7E7
nbpm_job ACTIONDELEGATION FK375F51937E4E3BFE
nbpm_logdetail DELEGATION FKD617A9EB52D4AD28
nbpm_node ASSIGNMENTDELEGATION FKB48CB2CCBDC5B3D5
nbpm_node DECISIONDELEGATION FKB48CB2CC16B99624
nbpm_node FORKDELEGATION FKB48CB2CCDB870B8A
nbpm_node JOINDELEGATION FKB48CB2CCDC6D79F2
nbpm_node PROCESSINVOKERDELEGATION FKB48CB2CCAA96D113
nbpm_processblock AUTHORIZATIONDELEGATION FKB1DE48450E681
ID nbpm_field bigint 20 0
ID nbpm_flow bigint 20 0
nbpm_attributeinstance SCOPE FK84748E876833E54
nbpm_flow PARENT FKB48905F8C4AB08AA
nbpm_job CONTEXT FK375F519338B735AF
nbpm_log FLOW FK375F591A30012E
nbpm_processinstance ROOTFLOW FK236E60DAF607B530
nbpm_processinstance SUPERPROCESSFLOW FK236E60DA2D1911C2
ID nbpm_job bigint 20 0
ID nbpm_log bigint 20 0
nbpm_logdetail LOG_ FKD617A9EB32C59B
ID nbpm_logdetail bigint 20 0
ID nbpm_membership bigint 20 0
ID nbpm_node 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
ID nbpm_processblock 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
ID nbpm_processinstance bigint 20 0
nbpm_flow PROCESSINSTANCE FKB48905F8842C3824
ID nbpm_transition bigint 20 0
IMAGE nbpm_processblock mediumblob 16277215  √  null
IMAGEHEIGHT nbpm_processblock int 11  √  null
IMAGEMIMETYPE nbpm_processblock varchar 255  √  null
IMAGEWIDTH nbpm_processblock int 11  √  null
INDEX_ nbpm_field int 11  √  null
INITIALVALUE nbpm_attribute varchar 255  √  null
INITIATORACTORID nbpm_processinstance varchar 255  √  null
JOINDELEGATION nbpm_node bigint 20  √  null
nbpm_delegation ID FKB48CB2CCDC6D79F2
JOIN_ nbpm_processblock bigint 20  √  null
nbpm_node ID FKB1DE48609C875
LASTNAME nbpm_actor varchar 255  √  null
LOG_ nbpm_logdetail bigint 20  √  null
nbpm_log ID FKD617A9EB32C59B
LONG_ nbpm_logdetail bigint 20  √  null
NAME nbpm_actor varchar 255  √  null
NAME nbpm_attribute varchar 255  √  null
NAME nbpm_field varchar 255  √  null
NAME nbpm_flow varchar 255  √  null
NAME nbpm_node varchar 255  √  null
NAME nbpm_processblock varchar 255  √  null
NAME nbpm_transition varchar 255  √  null
NODE nbpm_flow bigint 20  √  null
nbpm_node ID FKB48905F833AE02
PARENT nbpm_actor varchar 255  √  null
nbpm_actor ID FKDC4D3E4BC4AB08AA
PARENT nbpm_flow bigint 20  √  null
nbpm_flow ID FKB48905F8C4AB08AA
PARENTBLOCK nbpm_processblock bigint 20  √  null
nbpm_processblock ID FKB1DE483AE6A603
PARENTREACTIVATION nbpm_flow bit 1  √  null
PROCESSBLOCK nbpm_node bigint 20  √  null
nbpm_processblock ID FKB48CB2CC7534635E
PROCESSDEFINITION nbpm_assemblyfile bigint 20  √  null
nbpm_processblock ID FK44FE944AB7C43122
PROCESSDEFINITION nbpm_attribute bigint 20  √  null
nbpm_processblock ID FK46521BF2B7C43122
PROCESSDEFINITION nbpm_delegation bigint 20  √  null
nbpm_processblock ID FKBE986672B7C43122
PROCESSDEFINITION nbpm_job bigint 20  √  null
nbpm_processblock ID FK375F5193B7C43122
PROCESSDEFINITION nbpm_node bigint 20  √  null
nbpm_processblock ID FKB48CB2CCB7C43122
PROCESSDEFINITION nbpm_processblock bigint 20  √  null
nbpm_processblock ID FKB1DE48B7C43122
PROCESSDEFINITION nbpm_processinstance bigint 20  √  null
nbpm_processblock ID FK236E60DAB7C43122
PROCESSDEFINITION nbpm_transition bigint 20  √  null
nbpm_processblock ID FK4FF269FB7C43122
PROCESSINSTANCE nbpm_flow bigint 20  √  null
nbpm_processinstance ID FKB48905F8842C3824
PROCESSINVOKERDELEGATION nbpm_node bigint 20  √  null
nbpm_delegation ID FKB48CB2CCAA96D113
PWD nbpm_job varchar 255  √  null
REFERENCE nbpm_job varchar 255  √  null
RESPONSIBLEUSERNAME nbpm_processblock varchar 255  √  null
ROLE nbpm_membership varchar 255  √  null
ROOTFLOW nbpm_processinstance bigint 20  √  null
nbpm_flow ID FK236E60DAF607B530
SCOPE nbpm_attribute bigint 20  √  null
nbpm_processblock ID FK46521BF26833E54
SCOPE nbpm_attributeinstance bigint 20  √  null
nbpm_flow ID FK84748E876833E54
SERIALIZERDELEGATION nbpm_attribute bigint 20  √  null
nbpm_delegation ID FK46521BF2A061B05A
STARTSTATE nbpm_processblock bigint 20  √  null
nbpm_node ID FKB1DE48A1927D4F
START_ nbpm_flow datetime 19  √  null
START_ nbpm_processinstance datetime 19  √  null
STATE nbpm_field bigint 20  √  null
nbpm_node ID FKDC96355068AC491
SUBCLASS nbpm_actor varchar 255
SUBCLASS nbpm_logdetail varchar 255
SUBCLASS nbpm_node varchar 255
SUBCLASS nbpm_processblock varchar 255
SUBPROCESS nbpm_node bigint 20  √  null
nbpm_processblock ID FKB48CB2CC953D700F
SUPERPROCESSFLOW nbpm_processinstance bigint 20  √  null
nbpm_flow ID FK236E60DA2D1911C2
TEXT_ nbpm_logdetail varchar 255  √  null
TO_ nbpm_transition bigint 20  √  null
nbpm_node ID FK4FF269F1C144
TYPE_ nbpm_actor varchar 255  √  null
TYPE_ nbpm_log smallint 6  √  null
TYPE_ nbpm_membership varchar 255  √  null
USERID nbpm_job varchar 255  √  null
USER_ nbpm_membership varchar 255  √  null
nbpm_actor ID FK1BE141206A68DF4
VALUETEXT nbpm_attributeinstance varchar 255  √  null
VERSION_ nbpm_processblock int 11  √  null