Table ezp54_community.ezproductcollection_item_opt 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
id int 10  √ 
ezproductcollection_item_opt.option_item_id ezproductcollection_item_opt_ibfk_3 R
item_id int 10 0
ezproductcollection_item.id ezproductcollection_item_opt_ibfk_1 R
name varchar 255
object_attribute_id int 10  √  null
ezcontentobject_attribute.id ezproductcollection_item_opt_ibfk_2 R
option_item_id int 10 0
ezproductcollection_item_opt.id ezproductcollection_item_opt_ibfk_3 R
price float 12 0
value varchar 255

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
item_id Performance Asc ezproductcollection_item_opt_item_id
object_attribute_id Performance Asc object_attribute_id
option_item_id Performance Asc option_item_id

Close relationships  within of separation: