Table ezp54_community.ezinfocollection_attribute Generated by
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_attribute_id int 10 0 ezinfocollection_attribute_ibfk_1 R
contentobject_attribute_id int 10  √  null ezinfocollection_attribute_ibfk_2 R
contentobject_id int 10  √  null ezinfocollection_attribute_ibfk_3 R
data_float float 12  √  null
data_int int 10  √  null
data_text longtext 2147483647  √  null
id int 10  √ 
informationcollection_id int 10 0 ezinfocollection_attribute_ibfk_4 R

Analyzed at ? 7 07 11:43 CEST 2015

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contentclass_attribute_id Performance Asc ezinfocollection_attr_cca_id
contentobject_id Performance Asc ezinfocollection_attr_co_id
contentobject_attribute_id Performance Asc ezinfocollection_attr_coa_id
informationcollection_id Performance Asc ezinfocollection_attr_ic_id

Close relationships  within of separation: