users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('users_id_seq'::regclass)
annotation_assistance_requests.receiver_id annotation_assistance_requests_receiver_id_foreignN
annotation_assistance_requests.user_id annotation_assistance_requests_user_id_foreignC
annotation_session_user.user_id annotation_session_user_user_id_foreignC
api_tokens.owner_id api_tokens_owner_id_foreignC
federated_search_model_user.user_id federated_search_model_user_user_id_foreignC
image_annotation_labels.user_id annotation_labels_user_id_foreignN
image_labels.user_id image_labels_user_id_foreignN
label_tree_user.user_id label_tree_user_user_id_foreignC
lslogin_ids.user_id lslogin_ids_user_id_foreignC
maia_jobs.user_id maia_jobs_user_id_foreignN
project_user.user_id project_user_user_id_foreignC
projects.creator_id projects_creator_id_foreignN
reports.user_id reports_user_id_foreignC
storage_requests.user_id storage_requests_user_id_foreignC
user_disks.user_id user_disks_user_id_foreignC
video_annotation_labels.user_id video_annotation_labels_user_id_foreignN
video_labels.user_id video_labels_user_id_foreignN
volumes.creator_id transects_creator_id_foreignN
firstname varchar 128 null
lastname varchar 128 null
password varchar 60 null
email varchar 256 null
role_id int4 10 null
roles.id users_role_id_foreignR
remember_token varchar 100 √ null
created_at timestamp 22 √ null
updated_at timestamp 22 √ null
login_at timestamp 22 √ null
attrs json 2147483647 √ null
uuid uuid 2147483647 null
affiliation varchar 256 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc id
users_email_index Performance Asc email
users_email_unique Must be unique
users_uuid_unique Must be unique Asc uuid

Relationships

Close relationships within degrees of separation