User Preferences Table Schema (user_preferences)


Allows modules to store arbitrary user preferences

user_preferences table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
userid BIGINT 19 0 Implied Constraint R
name VARCHAR 255
value VARCHAR 1333

Table contained -1 rows

user_preferences table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userpref_usenam_uix Must be unique Asc/Asc userid + name

user_preferences table relationships