Schema:user preferences

From ISFDB

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.