Schema:awards

From ISFDB

Jump to: navigation, search

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    |                |
+--------------+------------+------+-----+---------+----------------+

Description

The awards table directly replicates the old ISFDB awards record format.

  • 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 - This column holds the title(s) of the work. Variant titles are currently separated by "^".
  • award_author - This column holds the author(s) of the work. Multiple authors are currently separated with a "+".
  • 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 - This column holds a two-letter award code: currently hard-coded, soon to be in a new award_types table.
    • 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 - 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
    • 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
    • 91 : Made First Ballot
    • 92 : Preliminary Nominee
    • 93 : Honorable Mention
    • 98 : Early Submission
    • 99 : Nomination Below Cutoff
  • award_movie - This column holds an IMDB-compatible title for a movie.
Retrieved from "http://www.isfdb.org/wiki/index.php/Schema:awards"
Personal tools