user

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id INT UNSIGNED 10 √ null
administrator.user_id admin_fk C
client.user_id client_fk C
comment.user_id comment_user_user_id_fk R
password_change_request.user_id request_fk C
email VARCHAR 320 null
first_name VARCHAR 255 null
password VARCHAR 255 null
phone_no VARCHAR 255 null
last_name VARCHAR 255 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_id
unique_email Must be unique Asc email

Relationships

Close relationships within degrees of separation