Table gym_trainer_development.admin_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('admin_users_id_seq'::regclass)
email varchar 2147483647 ''::character varying
encrypted_password varchar 2147483647 ''::character varying
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
created_at timestamp 29,6
updated_at timestamp 29,6

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

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