Schema:user sites

Schema Summary
+---+--+--+-+-++ | Field                | Type     | Null | Key | Default | Extra          | +---+--+--+-+-++ | user_site_id         | int(11)  | NO   | PRI | NULL    | auto_increment | | site_id              | int(11)  | YES  | MUL | NULL    |                | | user_id              | int(11)  | YES  | MUL | NULL    |                | | user_choice          | int(11)  | YES  |     | 1       |                | +---+--+--+-+-++

Description
The user_sites table is used to store user website preferences. Each entry is associated with a registered user ID.


 * user_site_id - Unique key ID.


 * site_id - Foreign key into websites table.


 * user_id - The user ID of the registered user.


 * user_choice - Flag to indicate if user chooses to view this site.