Table ezp54_community.ezcollab_group Generated by
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
depth int 10 0
id int 10  √ 
ezcollab_group.parent_group_id ezcollab_group_ibfk_1 R
ezcollab_item_group_link.group_id ezcollab_item_group_link_ibfk_2 R
ezcollab_profile.main_group ezcollab_profile_ibfk_1 R
is_open int 10 1
modified int 10 0
parent_group_id int 10 0 ezcollab_group_ibfk_1 R
path_string varchar 255
priority int 10 0
title varchar 255
user_id int 10 0
ezuser.contentobject_id ezcollab_group_ibfk_2 R

Analyzed at ? 7 07 11:43 CEST 2015

Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
depth Performance Asc ezcollab_group_depth
path_string Performance Asc ezcollab_group_path
parent_group_id Performance Asc parent_group_id
user_id Performance Asc user_id

Close relationships  within of separation: