SchemaSpy - Table ezp54_community.ezcollab_item_group_link

Generated by
SchemaSpy

Legend:

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