Difference between revisions of "Schema:awards"

From ISFDB
Jump to navigation Jump to search
(Good reminder to always check the preview before hitting save :-()
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
==Schema Summary==
 
==Schema Summary==
  
−
  +--------------+------------+------+-----+---------+----------------+
+
  +---------------+------------+------+-----+---------+----------------+
−
  | Field       | Type      | Null | Key | Default | Extra          |
+
  | Field         | Type      | Null | Key | Default | Extra          |
−
  +--------------+------------+------+-----+---------+----------------+
+
  +---------------+------------+------+-----+---------+----------------+
−
  | award_id     | int(11)    | NO  | PRI | NULL    | auto_increment |
+
  | award_id     | int(11)    | NO  | PRI | NULL    | auto_increment |
−
  | award_title | mediumtext | YES  |    | NULL    |                |
+
  | award_title   | mediumtext | YES  |    | NULL    |                |
−
  | award_author | mediumtext | YES  |    | NULL    |                |
+
  | award_author | mediumtext | YES  |    | NULL    |                |
−
  | award_year   | date      | YES  |    | NULL    |                |
+
  | award_year   | date      | YES  |    | NULL    |                |
−
  | award_ttype | varchar(8) | YES  |    | NULL    |                |
+
  | award_ttype   | varchar(8) | YES  |    | NULL    |                |
−
  | award_atype | mediumtext | YES  |    | NULL    |                |
+
  | award_atype   | mediumtext | YES  |    | NULL    |                |
−
  | award_level  | mediumtext | YES  |    | NULL    |                |
+
  | award_level   | mediumtext | YES  |    | NULL    |                |
−
  | award_movie | 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==
 
==Description==
  
−
The awards table directly replicates the old ISFDB awards record format.
+
* '''award_id''' - Unique record id for the awards table.
  
−
* '''award_id''' - This column is the unique record id for the awards table. An award may be referred to by this unique id.  
+
* '''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_title''' - This column holds the title(s) of the work. Variant titles are currently separated by "^".
+
* '''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_author''' - This column holds the author(s) of the work. Multiple authors are currently separated with a "+".
+
* '''award_year''' - The year of the award.  
  
−
* '''award_year''' - This column holds the year of the award, or sometimes the year of eligibility for the award, depending on award type.  
+
* '''award_ttype''' - A two-letter award code. '''No longer used'''.
  
−
* '''award_ttype''' - This column holds a two-letter award code: currently hard-coded, soon to be in a new award_types table.
+
* '''award_atype''' - Used to contain the description of the award, e.g. "Best Novella" or "Best Novel". '''No longer used'''.
−
** An = Analog Award
 
−
** Ap = Apollo Award
 
−
** Ar = Asimov's Readers' Poll
 
−
** As = Aurealis Award
 
−
** Au = Aurora Award
 
−
** Ax = Asimov's Undergraduate Award
 
−
** Bf = British Fantasy Award
 
−
** Bl = Balrog Award
 
−
** Bs = British Science Fiction Award
 
−
** Ca = John W. Campbell Memorial Award
 
−
** Cc = Compton Crook Award
 
−
** Cl = Arthur C. Clarke Award
 
−
** Cy = Chesley Award
 
−
** Dr = Deathrealm Award
 
−
** Dt = Ditmar Award
 
−
** En = Endeavour Award
 
−
** Ga = Gandalf Award
 
−
** Gd = Golden Duck Award
 
−
** Gg = Gaughan Award
 
−
** Hf = Hall of Fame Award
 
−
** Hm = HOMer Award
 
−
** Hu = Hugo Award
 
−
** If = International Fantasy Award
 
−
** Ih = Internation Horror Guild Award
 
−
** Im = Imaginaire Award
 
−
** Jc = John W. Campbell Award
 
−
** Lc = Locus Poll Award
 
−
** Lm = Lambda Award
 
−
** My = Mythopoeic Award
 
−
** Ne = Nebula Award
 
−
** Pk = Philip K. Dick Award
 
−
** Pr = Prometheus Award
 
−
** Rh = Retro Hugo Award
 
−
** Ry = Rhysling Award
 
−
** Sc = SF Chronicle Award
 
−
** Sf = SFBC Award
 
−
** Sk = Skylark Award
 
−
** Sn = Sunburst Award
 
−
** St = Bram Stoker Award
 
−
** Su = Sturgeon Award
 
−
** Sw = Sidewise Award
 
−
** Tp = James Tiptree, Jr. Award
 
−
** Wf = World Fantasy Award
 
−
** Wh = James White Award
 
  
−
* '''award_atype''' - This column holds an ASCII plain-text description of the award, for instance "Best Novella" or "Best Novel".
+
* '''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:
−
 
 
−
* '''award_level''' - This column holds an ASCII numeral (as well as other textual information, which precludes this being an int) that indicates the work's position in a poll (1, 2, 3, etc) or its nomination/win status. (Win=1, Nomination = 9.) Special Award Levels are:
 
 
** 71 : No Winner -- Insufficient Votes
 
** 71 : No Winner -- Insufficient Votes
 
** 72 : Not on ballot -- Insufficient Nominations
 
** 72 : Not on ballot -- Insufficient Nominations
Line 83: Line 40:
 
** 84 : Withdrawn - Official Publication in a Previous Year
 
** 84 : Withdrawn - Official Publication in a Previous Year
 
** 85 : Withdrawn - Ineligible
 
** 85 : Withdrawn - Ineligible
 +
** 90 : Finalists
 
** 91 : Made First Ballot
 
** 91 : Made First Ballot
 
** 92 : Preliminary Nominee
 
** 92 : Preliminary Nominee
Line 89: Line 47:
 
** 99 : Nomination Below Cutoff
 
** 99 : Nomination Below Cutoff
  
−
* '''award_movie''' - This column holds an IMDB-compatible title for a movie.
+
* '''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.
 +
 
 +
[[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.
Retrieved from "https://isfdb.org/wiki/index.php?title=Schema:awards&oldid=666640"