Table ezp54_community.ezcollab_item 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
created int 10 0
creator_id int 10 0
ezuser.contentobject_id ezcollab_item_ibfk_1 R
data_float1 float 12 0
data_float2 float 12 0
data_float3 float 12 0
data_int1 int 10 0
data_int2 int 10 0
data_int3 int 10 0
data_text1 longtext 2147483647
data_text2 longtext 2147483647
data_text3 longtext 2147483647
id int 10  √ 
ezapprove_items.collaboration_id ezapprove_items_ibfk_1 R
ezcollab_item_group_link.collaboration_id ezcollab_item_group_link_ibfk_1 R
ezcollab_item_message_link.collaboration_id ezcollab_item_message_link_ibfk_1 R
ezcollab_item_participant_link.collaboration_id ezcollab_item_participant_link_ibfk_1 R
ezcollab_item_status.collaboration_id ezcollab_item_status_ibfk_1 R
modified int 10 0
status int 10 1
type_identifier varchar 40

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
creator_id Performance Asc creator_id

Close relationships  within of separation: