Table gym_trainer_development.users Generated by
SchemaSpy
Legend: SourceForge.net
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('users_id_seq'::regclass)
five_by_five_setups.user_id fk_rails_4bcb9ad8b6 C
workout_templates.user_id workout_templates_user_id_fk R
workouts.user_id fk_rails_40b8fd8af6 C
email varchar 2147483647  √  null
password varchar 2147483647  √  null
created_at timestamp 29,6
updated_at timestamp 29,6
salt varchar 2147483647  √  null
units varchar 2147483647  √  null
seq_num varchar 2147483647  √  null
encrypted_token bpchar 12  √  null
encrypted_password varchar 2147483647  √  null
reset_password_token varchar 2147483647  √  null
reset_password_sent_at timestamp 29,6  √  null
remember_created_at timestamp 29,6  √  null
sign_in_count int4 10 0
current_sign_in_at timestamp 29,6  √  null
last_sign_in_at timestamp 29,6  √  null
current_sign_in_ip inet 2147483647  √  null
last_sign_in_ip inet 2147483647  √  null
connected_mobile bool 1  √  false
opened_from_mobile bool 1  √  false
active_development_user bool 1  √  false

Table contained 2 rows at Tue Feb 07 18:38 CET 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc users_pkey  
email Must be unique Asc index_users_on_email This unique column is also nullable
reset_password_token Must be unique Asc index_users_on_reset_password_token This unique column is also nullable

Close relationships  within of separation: