users


Description

All registered users, including authentication data and profile data.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id BIGINT 19 √ null
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
notifications.user_id notifications_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 '[]'
gossip TEXT 65535 √ NULL
date_last_email DATETIME 19 √ NULL
date_registered DATETIME 19 null
date_validated DATETIME 19 √ NULL
date_last_login DATETIME 19 √ NULL
must_change_password SMALLINT 5 √ NULL
auth_id BIGINT 19 √ NULL
auth_str VARCHAR 255 √ NULL
disabled SMALLINT 5 0
disabled_reason TEXT 65535 √ NULL
inline_help SMALLINT 5 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation