Schema:most reviewed
Jump to navigation
Jump to search
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.