Table ezp54_community.ezcollab_item_group_link 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
collaboration_id int 10 0
ezcollab_item.id ezcollab_item_group_link_ibfk_1 R
created int 10 0
group_id int 10 0
ezcollab_group.id ezcollab_item_group_link_ibfk_2 R
is_active int 10 1
is_read int 10 0
last_read int 10 0
modified int 10 0
user_id int 10 0
ezuser.contentobject_id ezcollab_item_group_link_ibfk_3 R

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
collaboration_id + group_id + user_id Primary key Asc/Asc/Asc PRIMARY
group_id Performance Asc group_id
user_id Performance Asc user_id

Close relationships  within of separation: