Table: user

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_user_id_seq'::regclass)
activity.user_id fk_activity_user C
comment.user_id fk_comment_user C
organization_user.user_id fk_organization_user_user C
project_task.user_id fk_project_task_user C
project_user.user_id fk_project_user_user C
translation_value.user_id fk_translation_value_user C
user_language.user_id fk_user_language_user C
username varchar 30  √  null
email varchar 255
password_hash varchar 255
lastname varchar 255  √  null
firstname varchar 255  √  null
address_id int4 10  √  null
address.id fk_user_address R

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc lilo_user_pkey  
address_id Performance Asc fk_user_address_idx  
username Must be unique Asc username_unique This unique column is also nullable

Close relationships  within of separation: