Difference between revisions of "Schema:most reviewed"
Jump to navigation
Jump to search
(Page creation) |
m (fmt) |
||
Line 1: | Line 1: | ||
==Schema Summary== | ==Schema Summary== | ||
− | +------------------+-------------+------+-----+---------+----------------+ | + | +------------------+-------------+------+-----+---------+----------------+ |
− | | Field | Type | Null | Key | Default | Extra | | + | | Field | Type | Null | Key | Default | Extra | |
− | +------------------+-------------+------+-----+---------+----------------+ | + | +------------------+-------------+------+-----+---------+----------------+ |
− | | most_reviewed_id | int(11) | NO | PRI | NULL | auto_increment | | + | | most_reviewed_id | int(11) | NO | PRI | NULL | auto_increment | |
− | | title_id | int(11) | YES | | NULL | | | + | | title_id | int(11) | YES | | NULL | | |
− | | year | int(11) | YES | MUL | NULL | | | + | | year | int(11) | YES | MUL | NULL | | |
− | | decade | varchar(20) | YES | MUL | NULL | | | + | | decade | varchar(20) | YES | MUL | NULL | | |
− | | reviews | int(11) | YES | | NULL | | | + | | reviews | int(11) | YES | | NULL | | |
− | +------------------+-------------+------+-----+---------+----------------+ | + | +------------------+-------------+------+-----+---------+----------------+ |
==Description== | ==Description== |
Latest revision as of 16:54, 24 June 2019
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.