Schema:award titles report
Jump to navigation
Jump to search
Schema Summary
+----------------+---------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+----------------+ | award_title_id | int(11) | NO | PRI | NULL | auto_increment | | title_id | int(11) | YES | | NULL | | | score | int(11) | YES | | NULL | | | year | int(11) | YES | MUL | NULL | | | decade | varchar(20) | YES | MUL | NULL | | | title_type | enum([see below]) | YES | MUL | NULL | | +----------------+---------------------+------+-----+---------+----------------+
Description
The "award_titles_report" table stores title IDs with the highest award/nomination score. It is regenerated by the nightly job. It is used by the "Titles Ranked by Awards and Nominations" reports accessible from the ISFDB Statistics and Top Lists page.
- award_title_id - Unique record id for the award_titles_report table.
- title_id - ID of the title record. Points to the "titles" table. Note that variant titles are folded into their parent titles.
- score - Numeric award score associated with each title ID. Wins are worth 50 points, nominations and second places are worth 35 points. For polls, third and lower places are worth (33-poll position) points.
- 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.
- title_type - An enumerated list of all currently supported title types: NOVEL, SHORTFICTION, etc.