Table ezp54_community.ezcontentobject 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
contentclass_id int 10 0
ezcontentclass.id ezcontentobject_ibfk_1 R
current_version int 10  √  null
id int 10  √ 
ezcobj_state_link.contentobject_id ezcobj_state_link_ibfk_1 R
ezcollab_item_participant_link.participant_id ezcollab_item_participant_link_ibfk_2 R
ezcontentobject_attribute.contentobject_id ezcontentobject_attribute_ibfk_2 R
ezcontentobject_link.from_contentobject_id ezcontentobject_link_ibfk_1 R
ezcontentobject_link.to_contentobject_id ezcontentobject_link_ibfk_2 R
ezcontentobject_name.contentobject_id ezcontentobject_name_ibfk_1 R
ezcontentobject_trash.contentobject_id ezcontentobject_trash_ibfk_1 R
ezcontentobject_version.contentobject_id ezcontentobject_version_ibfk_1 R
ezinfocollection.contentobject_id ezinfocollection_ibfk_1 R
ezinfocollection_attribute.contentobject_id ezinfocollection_attribute_ibfk_3 R
ezproductcollection_item.contentobject_id ezproductcollection_item_ibfk_1 R
ezsearch_object_word_link.contentobject_id ezsearch_object_word_link_ibfk_1 R
ezstarrating.contentobject_id ezstarrating_ibfk_1 R
ezstarrating_data.contentobject_id ezstarrating_data_ibfk_2 R
ezuser.contentobject_id ezuser_ibfk_1 R
ezuser_discountrule.contentobject_id ezuser_discountrule_ibfk_1 R
initial_language_id bigint 19 0
ezcontent_language.id ezcontentobject_ibfk_2 R
language_mask bigint 19 0
modified int 10 0
name varchar 255  √  null
owner_id int 10 0
ezuser.contentobject_id ezcontentobject_ibfk_3 R
published int 10 0
remote_id varchar 100  √  null
section_id int 10 0
ezsection.id ezcontentobject_ibfk_4 R
status int 10  √  0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
contentclass_id Performance Asc ezcontentobject_classid  
current_version Performance Asc ezcontentobject_currentversion  
language_mask Performance Asc ezcontentobject_lmask  
owner_id Performance Asc ezcontentobject_owner  
published Performance Asc ezcontentobject_pub  
remote_id Must be unique Asc ezcontentobject_remote_id This unique column is also nullable
status Performance Asc ezcontentobject_status  
initial_language_id Performance Asc initial_language_id  
section_id Performance Asc section_id  

Close relationships  within of separation: