SchemaSpy - Table eZ Publish.ezcontentobject_attribute

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

attribute_original_id

int

10

√

0

contentclassattribute_id

int

10

0

ezcontentclass_attribute.id

ezcontentobject_attribute_ibfk_1 R

contentobject_id

int

10

0

ezcontentobject.id

ezcontentobject_attribute_ibfk_2 R

data_float

float

12

√

null

data_int

int

10

√

null

data_text

longtext

2147483647

√

null

data_type_string

varchar

50

√

id

int

10

√

ezbinaryfile.contentobject_attribute_id	ezbinaryfile_ibfk_1 R
ezenumobjectvalue.contentobject_attribute_id	ezenumobjectvalue_ibfk_1 R
ezenumvalue.contentclass_attribute_id	ezenumvalue_ibfk_2 R
ezgmaplocation.contentobject_attribute_id	ezgmaplocation_ibfk_1 R
ezimagefile.contentobject_attribute_id	ezimagefile_ibfk_1 R
ezinfocollection_attribute.contentobject_attribute_id	ezinfocollection_attribute_ibfk_2 R
ezkeyword_attribute_link.objectattribute_id	ezkeyword_attribute_link_ibfk_2 R
ezmedia.contentobject_attribute_id	ezmedia_ibfk_1 R
ezmultipricedata.contentobject_attr_id	ezmultipricedata_ibfk_1 R
ezproductcollection_item_opt.object_attribute_id	ezproductcollection_item_opt_ibfk_2 R
ezstarrating.contentobject_attribute_id	ezstarrating_ibfk_2 R
ezstarrating_data.contentobject_attribute_id	ezstarrating_data_ibfk_3 R
ezurl_object_link.contentobject_attribute_id	ezurl_object_link_ibfk_1 R

language_code

varchar

20

language_id

int

10

0

sort_key_int

int

10

0

sort_key_string

varchar

255

version

int

10

0

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:

Column(s)	Type	Sort	Constraint Name
id + version	Primary key	Asc/Asc	PRIMARY
contentclassattribute_id	Performance	Asc	contentclassattribute_id
id	Performance	Asc	ezcontentobject_attr_id
contentobject_id + version + language_code	Performance	Asc/Asc/Asc	ezcontentobject_attribute_co_id_ver_lang_code
contentobject_id	Performance	Asc	ezcontentobject_attribute_contentobject_id
language_code	Performance	Asc	ezcontentobject_attribute_language_code
sort_key_int	Performance	Asc	sort_key_int
sort_key_string	Performance	Asc	sort_key_string