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.