users

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('tasknote.users_id_seq'::regclass)
notes.user_id notes_user_id_fk R
notes_created.user_id notes_created_user_id_fk R
tasks.user_id task_user_id_fk R
user_pwd_limits.user_id user_pwd_limits_user_id_fk R
user_tasks_done.user_id user_tasks_done_user_id_fk R
email varchar 100 null
password varchar 255 null
admin bool 1 false
created_at timestamp 29,6 null
inactivated_at timestamp 29,6 √ null
name varchar 20 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pk Primary key Asc id
users_email_uk Must be unique Asc email

Relationships

Close relationships within degrees of separation