Schema:award types
Jump to navigation
Jump to search
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.