user

19 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('user_id_seq'::regclass)
application.user_id application_user_id_fkeyR
file.user_id file_user_id_fkeyR
notification.user_id notification_user_id_fkeyR
permission_join.user_id permission_join_user_id_fkeyR
permissions_all.userId Implied ConstraintR
review.reviewer_id review_reviewer_id_fkeyR
review_assignment.assigner_id review_assignment_assigner_id_fkeyR
review_assignment.reviewer_id review_assignment_reviewer_id_fkeyR
review_assignment_assigner_join.assigner_id review_assignment_assigner_join_assigner_id_fkeyR
user_organisation.user_id user_organisation_user_id_fkeyR
first_name varchar 2147483647 √ null
last_name varchar 2147483647 √ null
username varchar 2147483647 √ null
email varchar 2147483647 √ null
date_of_birth varchar 2147483647 √ null
password_hash varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc id
user_username_key Must be unique Asc username

Relationships

Close relationships within degrees of separation