users

46 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id BIGINT 19 √ null
access_keys.user_id Implied Constraint R
completed_payments.user_id Implied Constraint R
email_log_users.user_id Implied Constraint R
event_log.user_id Implied Constraint R
item_views.user_id Implied Constraint R
notes.user_id Implied Constraint R
notification_subscription_settings.user_id Implied Constraint R
notifications.user_id Implied Constraint R
query_participants.user_id Implied Constraint R
sessions.user_id Implied Constraint R
stage_assignments.user_id Implied Constraint R
subeditor_submission_group.user_id Implied Constraint R
submission_files.uploader_user_id Implied Constraint R
subscriptions.user_id Implied Constraint R
temporary_files.user_id Implied Constraint R
user_interests.user_id Implied Constraint R
user_settings.user_id Implied Constraint R
user_user_groups.user_id Implied Constraint R
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 √ NULL
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_sources.auth_id Implied Constraint R
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