Table ezp54_community.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 double 22  √  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 bigint 19 0
sort_key_int int 10 0
sort_key_string varchar 255
version int 10 0

Analyzed at ? 7 07 11:43 CEST 2015

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

Close relationships  within of separation: