Schema:most reviewed

Schema Summary

+------------------+-------------+------+-----+---------+----------------+
| Field            | Type        | Null | Key | Default | Extra          |
+------------------+-------------+------+-----+---------+----------------+
| most_reviewed_id | int(11)     | NO   | PRI | NULL    | auto_increment |
| title_id         | int(11)     | YES  |     | NULL    |                |
| year             | int(11)     | YES  | MUL | NULL    |                |
| decade           | varchar(20) | YES  | MUL | NULL    |                |
| reviews          | int(11)     | YES  |     | NULL    |                |
+------------------+-------------+------+-----+---------+----------------+

Description

The "most_reviewed" table stores title IDs with the highest number of linked reviews in the database. It is regenerated by the nightly job. It is used by the reports accessible from the Most-Reviewed Titles table.

• most_reviewed_id - Unique record id for the most_reviewed table.

• title_id - ID of the title record. Points to the "titles" table. Note that variant titles are folded into their parent titles.

• year - 4-digit year of the title.

• decade - 4-digit decade of the title for titles published in 1900 and later. "Pre1900" for titles published prior to 1900.

• reviews - Number of reviews linked to this title.