accounts

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id serial 10 √ nextval('accounts_user_id_seq'::regclass)
username varchar 50 null
password varchar 50 null
email varchar 255 null
created_on timestamp 29,6 null
last_login timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
accounts_pkey Primary key Asc user_id
accounts_email_key Must be unique Asc email
accounts_username_key Must be unique Asc username

Relationships

Close relationships within degrees of separation