Table: invitation

Columns
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
id serial 10  √  nextval('lilo_invitation_id_seq'::regclass)
organization_id int4 10  √  null
organization.id fk_invitation_organization C
project_id int4 10  √  null
project.id fk_invitation_project C
email varchar 255
role int2 5 0
languages text 2147483647  √  null
creationdate timestamp 29,6

Table contained 35 rows at Mon Apr 04 23:14 CEST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc lilo_invitation_pkey
organization_id Performance Asc fk_invitation_organization_idx
project_id Performance Asc fk_invitation_roject_idx

Close relationships  within of separation: