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?