Schema:user languages

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?