Difference between revisions of "Schema:user languages"
Jump to navigation
Jump to search
(New page: ==Schema Summary== +-----------------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------...) |
|||
Line 13: | Line 13: | ||
==Description== | ==Description== | ||
− | The | + | The user_languages table is used to store user language preferences. Each entry is associated with a registered user ID. |
* '''user_lang_id''' - Unique key ID. | * '''user_lang_id''' - Unique key ID. |
Latest revision as of 14:03, 1 July 2011
Schema Summary
+-----------------------+----------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------------------+----------+------+-----+---------+----------------+ | user_lang_id | int(11) | NO | PRI | NULL | auto_increment | | user_id | int(11) | YES | MUL | NULL | | | lang_id | int(11) | YES | MUL | NULL | | | user_choice | int(11) | YES | | NULL | | +-----------------------+----------+------+-----+---------+----------------+
Description
The user_languages table is used to store user language preferences. Each entry is associated with a registered user ID.
- user_lang_id - Unique key ID.
- user_id - The user ID of the registered user.
- lang_id - Foreign key into languages table.
- user_choice - Flag to indicate if user chooses to view titles in this language?