Table ezp54_community.ezproductcollection_item 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
contentobject_id int 10 0
ezcontentobject.id ezproductcollection_item_ibfk_1 R
discount float 12  √  null
id int 10  √ 
ezproductcollection_item_opt.item_id ezproductcollection_item_opt_ibfk_1 R
is_vat_inc int 10  √  null
item_count int 10 0
name varchar 255
price float 12  √  0
productcollection_id int 10 0
ezproductcollection.id ezproductcollection_item_ibfk_2 R
vat_value float 12  √  null

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contentobject_id Performance Asc ezproductcollection_item_contentobject_id
productcollection_id Performance Asc ezproductcollection_item_productcollection_id

Close relationships  within of separation: