SchemaSpy - Table eZ Publish.ezcontentobject

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

contentclass_id

int

10

0

ezcontentclass.id

ezcontentobject_ibfk_1 R

current_version

int

10

√

null

id

int

10

√

ezcobj_state_link.contentobject_id	ezcobj_state_link_ibfk_1 R
ezcollab_item_participant_link.participant_id	ezcollab_item_participant_link_ibfk_2 R
ezcontentobject_attribute.contentobject_id	ezcontentobject_attribute_ibfk_2 R
ezcontentobject_link.from_contentobject_id	ezcontentobject_link_ibfk_1 R
ezcontentobject_link.to_contentobject_id	ezcontentobject_link_ibfk_2 R
ezcontentobject_name.contentobject_id	ezcontentobject_name_ibfk_1 R
ezcontentobject_trash.contentobject_id	ezcontentobject_trash_ibfk_1 R
ezcontentobject_version.contentobject_id	ezcontentobject_version_ibfk_1 R
ezinfocollection.contentobject_id	ezinfocollection_ibfk_1 R
ezinfocollection_attribute.contentobject_id	ezinfocollection_attribute_ibfk_3 R
ezproductcollection_item.contentobject_id	ezproductcollection_item_ibfk_1 R
ezsearch_object_word_link.contentobject_id	ezsearch_object_word_link_ibfk_1 R
ezstarrating.contentobject_id	ezstarrating_ibfk_1 R
ezstarrating_data.contentobject_id	ezstarrating_data_ibfk_2 R
ezuser.contentobject_id	ezuser_ibfk_1 R
ezuser_discountrule.contentobject_id	ezuser_discountrule_ibfk_1 R

initial_language_id

int

10

0

ezcontent_language.id

ezcontentobject_ibfk_2 R

language_mask

int

10

0

modified

int

10

0

name

varchar

255

√

null

owner_id

int

10

0

ezuser.contentobject_id

ezcontentobject_ibfk_3 R

published

int

10

0

remote_id

varchar

100

√

null

section_id

int

10

0

ezcontentobject_ibfk_4 R

status

int

10

√

0

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	PRIMARY
contentclass_id	Performance	Asc	ezcontentobject_classid
current_version	Performance	Asc	ezcontentobject_currentversion
language_mask	Performance	Asc	ezcontentobject_lmask
owner_id	Performance	Asc	ezcontentobject_owner
published	Performance	Asc	ezcontentobject_pub
remote_id	Must be unique	Asc	ezcontentobject_remote_id	This unique column is also nullable
status	Performance	Asc	ezcontentobject_status
initial_language_id	Performance	Asc	initial_language_id
section_id	Performance	Asc	section_id