Table ezp54_community.ezcontentclass_attribute 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
can_translate int 10  √  1
category varchar 25
contentclass_id int 10 0
ezcontentclass.id ezcontentclass_attribute_ibfk_1 R
data_float1 double 22  √  null
data_float2 double 22  √  null
data_float3 double 22  √  null
data_float4 double 22  √  null
data_int1 int 10  √  null
data_int2 int 10  √  null
data_int3 int 10  √  null
data_int4 int 10  √  null
data_text1 varchar 50  √  null
data_text2 varchar 50  √  null
data_text3 varchar 50  √  null
data_text4 varchar 255  √  null
data_text5 longtext 2147483647  √  null
data_type_string varchar 50
id int 10  √ 
ezcontentobject_attribute.contentclassattribute_id ezcontentobject_attribute_ibfk_1 R
ezenumvalue.contentclass_attribute_id ezenumvalue_ibfk_1 R
ezinfocollection_attribute.contentclass_attribute_id ezinfocollection_attribute_ibfk_1 R
ezwaituntildatevalue.contentclass_attribute_id ezwaituntildatevalue_ibfk_1 R
identifier varchar 50
is_information_collector int 10 0
is_required int 10 0
is_searchable int 10 0
placement int 10 0
serialized_data_text longtext 2147483647  √  null
serialized_description_list longtext 2147483647  √  null
serialized_name_list longtext 2147483647
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
contentclass_id Performance Asc ezcontentclass_attr_ccid

Close relationships  within of separation: