Schema:user preferences
Jump to navigation
Jump to search
Schema Summary
+-----------------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+----------+------+-----+---------+----------------+ | user_pref_id | int(11) | NO | PRI | NULL | auto_increment | | user_id | int(11) | YES | MUL | NULL | | | concise_disp | int(1) | YES | MUL | NULL | | | display_all_languages | int(1) | YES | | NULL | | +-----------------------+----------+------+-----+---------+----------------+
Description
The user_preferences table is used to store user preferences. Each entry is associated with a registered user ID.
- user_pref_id - Unique key ID.
- user_id - The user ID of the registered user.
- concise_disp - Flag to indicate whether user prefers a concise display.
- display_all_languages - Flag to indicate whether user is happy to display all languages.