Difference between revisions of "Schema:awards"
Jump to navigation
Jump to search
(Add category) |
(Good reminder to always check the preview before hitting save :-() |
||
Line 55: | Line 55: | ||
* '''award_note_id''' - ID of the note associated with this award. A pointer to the "notes" table. | * '''award_note_id''' - ID of the note associated with this award. A pointer to the "notes" table. | ||
− | [[Category | + | [[Category:Awards]] |
Latest revision as of 08:04, 7 July 2023
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.