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

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.