Schema:award titles report

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.