Table: comment

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_comment_id_seq'::regclass)
type int2 5 0
date timestamp 29,6
user_id int4 10
user.id fk_comment_user C
project_id int4 10
project.id fk_comment_project C
translation_field_id int4 10  √  null
translation_field.id fk_comment_translation_field C
language_id varchar 6  √  null
language.id fk_comment_language C
text text 2147483647

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc lilo_comment_pkey
language_id Performance Asc fk_comment_language_idx
project_id Performance Asc fk_comment_project_idx
translation_field_id Performance Asc fk_comment_translation_field_idx
user_id Performance Asc fk_comment_user_idx

Close relationships  within of separation: