Table ezp54_community.ezworkflow_process Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
activation_date int 10  √  null
content_id int 10 0
content_version int 10 0
created int 10 0
event_id int 10 0
event_position int 10 0
event_state int 10  √  null
event_status int 10 0
id int 10  √ 
ezapprove_items.workflow_process_id ezapprove_items_ibfk_2 R
ezpaymentobject.workflowprocess_id ezpaymentobject_ibfk_2 R
last_event_id int 10 0
last_event_position int 10 0
last_event_status int 10 0
memento_key varchar 32  √  null
ezoperation_memento.memento_key ezworkflow_process_ibfk_1 R
modified int 10 0
node_id int 10 0
parameters longtext 2147483647  √  null
process_key varchar 32
session_key varchar 32 0
status int 10  √  null
user_id int 10 0
ezuser.contentobject_id ezworkflow_process_ibfk_2 R
workflow_id int 10 0
ezworkflow.id ezworkflow_process_ibfk_3 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
process_key Performance Asc ezworkflow_process_process_key
memento_key Performance Asc memento_key
user_id Performance Asc user_id
workflow_id Performance Asc workflow_id

Close relationships  within of separation: