SchemaSpy - Table eZ Publish.ezproductcollection_item_opt

Generated by
SchemaSpy

Legend:

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 Mon Jan 02 16:38 CET 2012

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