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 of the work.

• award_author - This column holds the author of the work.

• award_year - This column holds the date of the award.

• award_ttype - This column holds a two-letter award code:
  • 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 works position in a poll (1, 2, 3, etc) or its nomination/win status.

• award_movie - This column holds an IMDB-compatible title for a movie.