Table eZ Publish.ezinfocollection_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
contentclass_attribute_id int 10 0
ezcontentclass_attribute.id ezinfocollection_attribute_ibfk_1 R
contentobject_attribute_id int 10  √  null
ezcontentobject_attribute.id ezinfocollection_attribute_ibfk_2 R
contentobject_id int 10  √  null
ezcontentobject.id 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.id ezinfocollection_attribute_ibfk_4 R

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:
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: