Table ezp54_community.ezcontentobject_version 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
contentobject_id int 10  √  null
ezcontentobject.id ezcontentobject_version_ibfk_1 R
created int 10 0
creator_id int 10 0
id int 10  √ 
ezpublishingqueueprocesses.ezcontentobject_version_id ezpublishingqueueprocesses_ibfk_1 R
initial_language_id bigint 19 0
ezcontent_language.id ezcontentobject_version_ibfk_2 R
language_mask bigint 19 0
modified int 10 0
status int 10 0
user_id int 10 0
version int 10 0
workflow_event_pos int 10  √  0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
creator_id Performance Asc ezcobj_version_creator_id
status Performance Asc ezcobj_version_status
contentobject_id + status Performance Asc/Asc ezcontobj_version_obj_status
contentobject_id + version Performance Asc/Asc idx_object_version_objver
initial_language_id Performance Asc initial_language_id

Close relationships  within of separation: