Table eZ Publish.ezcontentobject_attribute 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
attribute_original_id int 10  √  0
contentclassattribute_id int 10 0
ezcontentclass_attribute.id ezcontentobject_attribute_ibfk_1 R
contentobject_id int 10 0
ezcontentobject.id ezcontentobject_attribute_ibfk_2 R
data_float float 12  √  null
data_int int 10  √  null
data_text longtext 2147483647  √  null
data_type_string varchar 50  √ 
id int 10  √ 
ezbinaryfile.contentobject_attribute_id ezbinaryfile_ibfk_1 R
ezenumobjectvalue.contentobject_attribute_id ezenumobjectvalue_ibfk_1 R
ezenumvalue.contentclass_attribute_id ezenumvalue_ibfk_2 R
ezgmaplocation.contentobject_attribute_id ezgmaplocation_ibfk_1 R
ezimagefile.contentobject_attribute_id ezimagefile_ibfk_1 R
ezinfocollection_attribute.contentobject_attribute_id ezinfocollection_attribute_ibfk_2 R
ezkeyword_attribute_link.objectattribute_id ezkeyword_attribute_link_ibfk_2 R
ezmedia.contentobject_attribute_id ezmedia_ibfk_1 R
ezmultipricedata.contentobject_attr_id ezmultipricedata_ibfk_1 R
ezproductcollection_item_opt.object_attribute_id ezproductcollection_item_opt_ibfk_2 R
ezstarrating.contentobject_attribute_id ezstarrating_ibfk_2 R
ezstarrating_data.contentobject_attribute_id ezstarrating_data_ibfk_3 R
ezurl_object_link.contentobject_attribute_id ezurl_object_link_ibfk_1 R
language_code varchar 20
language_id int 10 0
sort_key_int int 10 0
sort_key_string varchar 255
version int 10 0

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:
Column(s) Type Sort Constraint Name
id + version Primary key Asc/Asc PRIMARY
contentclassattribute_id Performance Asc contentclassattribute_id
id Performance Asc ezcontentobject_attr_id
contentobject_id + version + language_code Performance Asc/Asc/Asc ezcontentobject_attribute_co_id_ver_lang_code
contentobject_id Performance Asc ezcontentobject_attribute_contentobject_id
language_code Performance Asc ezcontentobject_attribute_language_code
sort_key_int Performance Asc sort_key_int
sort_key_string Performance Asc sort_key_string

Close relationships  within of separation: