users


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 √ null
addressbook_subscriptions.user_id addressbook_subscriptions_user_id_foreign C
addressbooks.user_id addressbooks_user_id_foreign C
audit_logs.author_id audit_logs_author_id_foreign N
export_jobs.user_id export_jobs_user_id_foreign C
import_job_reports.user_id import_job_reports_user_id_foreign C
import_jobs.user_id import_jobs_user_id_foreign C
invitations.invited_by_user_id invitations_invited_by_user_id_foreign C
recovery_codes.user_id recovery_codes_user_id_foreign C
reminder_outbox.user_id reminder_outbox_user_id_foreign C
synctoken.user_id synctoken_user_id_foreign C
term_user.user_id term_user_user_id_foreign C
u2f_key.user_id u2f_key_user_id_foreign C
users.invited_by_user_id users_invited_by_user_id_foreign N
webauthn_keys.user_id webauthn_keys_user_id_foreign C
uuid CHAR 36 √ null
first_name VARCHAR 255 null
last_name VARCHAR 255 null
email VARCHAR 255 null
me_contact_id INT UNSIGNED 10 √ null
contacts.id users_me_contact_id_foreign N
admin BIT 1 0
email_verified_at TIMESTAMP 19 √ null
password VARCHAR 255 null
remember_token VARCHAR 100 √ null
google2fa_secret VARCHAR 256 √ null
account_id INT UNSIGNED 10 null
accounts.id users_account_id_foreign C
timezone VARCHAR 255 √ null
currency_id INT UNSIGNED 10 √ 2
currencies.id users_currency_id_foreign N
locale VARCHAR 255 en
metric VARCHAR 255 fahrenheit
fluid_container VARCHAR 255 false
contacts_sort_order VARCHAR 255 firstnameAZ
name_order VARCHAR 255 firstname_lastname_nickname
invited_by_user_id INT UNSIGNED 10 √ null
users.id users_invited_by_user_id_foreign N
dashboard_active_tab VARCHAR 255 calls
gifts_active_tab VARCHAR 255 ideas
profile_active_tab VARCHAR 255 notes
profile_new_life_event_badge_seen BIT 1 0
temperature_scale VARCHAR 255 √ celsius
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
users_account_id_uuid_index Performance Asc/Asc account_id + uuid
users_currency_id_foreign Performance Asc currency_id
users_email_unique Must be unique Asc email
users_invited_by_user_id_foreign Performance Asc invited_by_user_id
users_me_contact_id_foreign Performance Asc me_contact_id

Relationships

Close relationships within degrees of separation