Table: project

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_project_id_seq'::regclass)
comment.project_id fk_comment_project C
invitation.project_id fk_invitation_project C
progress.project_id fk_progress_project C
project_language.project_id fk_project_language_project C
project_task.project_id fk_project_task_project C
project_user.project_id fk_project_user_project C
translation_field.project_id fk_translation_field_project C
translation_group.project_id fk_translation_group_project C
name varchar 255
identifier varchar 45
is_public int2 5 1
description text 2147483647  √  null
default_language_id varchar 6  √  null
language.id fk_project_default_language C
default_role int2 5 0
organization_id int4 10  √  null
organization.id fk_project_organization C

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc lilo_project_pkey
organization_id Performance Asc fk_organization_idx
default_language_id Performance Asc fk_project_default_language_idx

Close relationships  within of separation: