Table ezp54_community.ezcontentclass 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
always_available int 10 0
contentobject_name varchar 255  √  null
created int 10 0
creator_id int 10 0
ezuser.contentobject_id ezcontentclass_ibfk_1 R
id int 10  √ 
ezcontentclass_attribute.contentclass_id ezcontentclass_attribute_ibfk_1 R
ezcontentclass_classgroup.contentclass_id ezcontentclass_classgroup_ibfk_1 R
ezcontentclass_name.contentclass_id ezcontentclass_name_ibfk_1 R
ezcontentobject.contentclass_id ezcontentobject_ibfk_1 R
ezkeyword.class_id ezkeyword_ibfk_1 R
ezrss_export_item.class_id ezrss_export_item_ibfk_1 R
ezrss_import.class_id ezrss_import_ibfk_1 R
ezsearch_object_word_link.contentclass_id ezsearch_object_word_link_ibfk_2 R
ezwaituntildatevalue.contentclass_id ezwaituntildatevalue_ibfk_2 R
identifier varchar 50
initial_language_id bigint 19 0
ezcontent_language.id ezcontentclass_ibfk_2 R
is_container int 10 0
language_mask bigint 19 0
modified int 10 0
modifier_id int 10 0
ezuser.contentobject_id ezcontentclass_ibfk_3 R
remote_id varchar 100
serialized_description_list longtext 2147483647  √  null
serialized_name_list longtext 2147483647  √  null
sort_field int 10 1
sort_order int 10 1
url_alias_name varchar 255  √  null
version int 10 0

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id + version Primary key Asc/Asc PRIMARY
creator_id Performance Asc creator_id
identifier + version Performance Asc/Asc ezcontentclass_identifier
version Performance Asc ezcontentclass_version
initial_language_id Performance Asc initial_language_id
modifier_id Performance Asc modifier_id

Close relationships  within of separation: