Schema:votes

Schema Summary

+----------+---------+------+-----+---------+----------------+
| Field    | Type    | Null | Key | Default | Extra          |
+----------+---------+------+-----+---------+----------------+
| vote_id  | int(11) | NO   | PRI | NULL    | auto_increment |
| title_id | int(11) | YES  | MUL | NULL    |                |
| user_id  | int(11) | YES  | MUL | NULL    |                |
| rating   | int(11) | YES  |     | NULL    |                |
+----------+---------+------+-----+---------+----------------+

Description

This table tracks the vote for a particular title by a particular user.

• vote_id - This column is the unique record id for the votes table. A vote may be referred to by this unique id.

• title_id - The id of the title record.

• user_id - The id of the user record.

• rating - The vote, ranging from 1 (very bad) to 10 (very good).