Schema:awards

Schema Summary

+---------------+------------+------+-----+---------+----------------+
| Field         | Type       | Null | Key | Default | Extra          |
+---------------+------------+------+-----+---------+----------------+
| award_id      | int(11)    | NO   | PRI | NULL    | auto_increment |
| award_title   | mediumtext | YES  |     | NULL    |                |
| award_author  | mediumtext | YES  |     | NULL    |                |
| award_year    | date       | YES  |     | NULL    |                |
| award_ttype   | varchar(8) | YES  |     | NULL    |                |
| award_atype   | mediumtext | YES  |     | NULL    |                |
| award_level   | mediumtext | YES  |     | NULL    |                |
| award_movie   | mediumtext | YES  |     | NULL    |                |
| award_type_id | int(11)    | YES  | MUL | NULL    |                |
| award_cat_id  | int(11)    | YES  | MUL | NULL    |                |
| award_note_id | int(11)    | YES  |     | NULL    |                |
+---------------+------------+------+-----+---------+----------------+

Description

• award_id - Unique record id for the awards table.

• award_title - The title of the award. For title-based awards it's the same as the title of the work at the time the award was created. (Note that it's not used for display purposes; the current title is used instead.) For awards associated with a work that is not in ISFDB, e.g. a magazine or a non-genre reference book, this is the work's title. For awards not associated with a work, e.g. Best Artist or Best Book Publisher, this field contains the word "untitled".

• award_author - The author(s) for this award. Multiple authors are currently separated with a "+". For title-based awards it's the same as the author(s) of the work at the time the award was created. (Note that it's not used for display purposes; the current authors are used instead.) For awards not associated with a title, this field contains the canonical name of the author as it is currently defined in the ISFDB. It is used to link the award to its author.

• award_year - The year of the award.

• award_ttype - A two-letter award code. No longer used.

• award_atype - Used to contain the description of the award, e.g. "Best Novella" or "Best Novel". No longer used.

• award_level - A numeric value between 1 and 99. For poll-based award types, it's the work's position in a poll and should be between 1 and 70. For non-poll-based award types, it is 1 for wins and 9 for nominations. Values between 71 and 99 are considered "special" and have the following meanings:
  • 71 : No Winner -- Insufficient Votes
  • 72 : Not on ballot -- Insufficient Nominations
  • 73 : No Award Given This Year
  • 81 : Withdrawn
  • 82 : Withdrawn - Nomination Declined
  • 83 : Withdrawn - Conflict of Interest
  • 84 : Withdrawn - Official Publication in a Previous Year
  • 85 : Withdrawn - Ineligible
  • 90 : Finalists
  • 91 : Made First Ballot
  • 92 : Preliminary Nominee
  • 93 : Honorable Mention
  • 98 : Early Submission
  • 99 : Nomination Below Cutoff

• award_movie - Only populated for movie awards. Contains the title of the movie in the IMDB database.

• award_type_id - ID of the award type associated with this award. A pointer to the "award_types" tables.

• award_cat_id - ID of the award category associated with this award. A pointer to the "award_cats" table.

• award_note_id - ID of the note associated with this award. A pointer to the "notes" table.