users

1 rows


Description

All registered users, including authentication data and profile data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id bigserial 19 √ nextval('users_user_id_seq'::regclass)
access_keys.user_id access_keys_user_id_foreignC
completed_payments.user_id completed_payments_user_id_foreignN
edit_decisions.editor_id edit_decisions_editor_idC
email_log_users.user_id email_log_users_user_id_foreignC
event_log.user_id event_log_user_id_foreignC
notes.user_id notes_user_id_foreignC
notification_subscription_settings.user_id notification_subscription_settings_user_id_foreignC
query_participants.user_id query_participants_user_id_foreignC
review_assignments.reviewer_id review_assignments_reviewer_id_foreignR
sessions.user_id sessions_user_idC
stage_assignments.user_id stage_assignments_user_idC
subeditor_submission_group.user_id subeditor_submission_group_user_idC
submission_comments.author_id submission_comments_author_id_foreignC
submission_files.uploader_user_id submission_files_uploader_user_id_foreignN
temporary_files.user_id temporary_files_user_idC
user_interests.user_id user_interests_user_id_foreignC
user_settings.user_id user_settings_user_id_foreignC
user_user_groups.user_id user_user_groups_user_idC
username varchar 32 null
password varchar 255 null
email varchar 255 null
url varchar 2047 √ null
phone varchar 32 √ null
mailing_address varchar 255 √ null
billing_address varchar 255 √ null
country varchar 90 √ null
locales varchar 255 '[]'::character varying
gossip text 2147483647 √ null
date_last_email timestamp 22 √ null
date_registered timestamp 22 null
date_validated timestamp 22 √ null
date_last_login timestamp 22 √ null
must_change_password int2 5 √ null
auth_id int8 19 √ null
auth_str varchar 255 √ null
disabled int2 5 '0'::smallint
disabled_reason text 2147483647 √ null
inline_help int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
users_pkey Primary key Asc user_id
users_email Must be unique
users_username Must be unique

Relationships

Close relationships within degrees of separation