Schema:award types

Schema Summary

+-----------------------+------------------+------+-----+---------+----------------+
| Field                 | Type             | Null | Key | Default | Extra          |
+-----------------------+------------------+------+-----+---------+----------------+
| award_type_id         | int(11)          | NO   | PRI | NULL    | auto_increment |
| award_type_code       | varchar(5)       | YES  |     | NULL    |                |
| award_type_name       | mediumtext       | YES  |     | NULL    |                |
| award_type_wikipedia  | mediumtext       | YES  |     | NULL    |                |
| award_type_note_id    | int(11)          | YES  |     | NULL    |                |
| award_type_by         | mediumtext       | YES  |     | NULL    |                |
| award_type_for        | mediumtext       | YES  |     | NULL    |                |
| award_type_short_name | mediumtext       | YES  |     | NULL    |                |
| award_type_poll       | enum('Yes','No') | YES  |     | NULL    |                |
| award_type_non_genre  | enum('Yes','No') | YES  |     | NULL    |                |
+-----------------------+------------------+------+-----+---------+----------------+

Description

• award_type_id - Unique primary key.
• award_type_code - A two-letter abbreviation for this award type. Obsolete and no longer used.
• award_type_name - Full name of the award type.
• award_type_wikipedia - URL of the related Wikipedia article. Obsolete and no longer used.
• award_type_note_id - ID of the record in the note table where the note for this award type is stored.
• award_type_by - The name of the group or organization who gives the award.
• award_type_for - What the award is given for.
• award_type_short_name - Commonly used shortened name of this award type, e.g. "Hugo".
• award_type_poll - A 0/1 flag indicating whether this award type uses ranked polls (1) or unranked nominations (0).
• award_type_non_genre - A 0/1 flag indicating whether this award type is primary for non-genre works.