Schema:user sites
Jump to navigation
Jump to search
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.