user_settings


Description

More data about users, including localized properties like their name and affiliation.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_setting_id BIGINT UNSIGNED 20 null
user_id BIGINT 19 null
users.user_id user_settings_user_id_foreignC
locale VARCHAR 14 ''
setting_name VARCHAR 255 null
setting_value MEDIUMTEXT 16777215 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc user_setting_id
user_settings_locale_setting_name_index Performance Asc/Asc setting_name + locale
user_settings_unique Must be unique Asc/Asc/Asc user_id + locale + setting_name
user_settings_user_id Performance Asc user_id

Relationships