SchemaSpy - Table eZ Publish.ezcollab_item_participant_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_participant_link_ibfk_1 R

created

int

10

0

is_active

int

10

1

is_read

int

10

0

last_read

int

10

0

modified

int

10

0

participant_id

int

10

0

ezcontentobject.id

ezcollab_item_participant_link_ibfk_2 R

participant_role

int

10

1

participant_type

int

10

1

Analyzed at Mon Jan 02 16:38 CET 2012

Indexes:

Column(s)	Type	Sort	Constraint Name
collaboration_id + participant_id	Primary key	Asc/Asc	PRIMARY
participant_id	Performance	Asc	participant_id