Schema:award cats

From ISFDB

Jump to: navigation, search

Schema Summary

+-------------------+------------+------+-----+---------+----------------+
| Field             | Type       | Null | Key | Default | Extra          |
+-------------------+------------+------+-----+---------+----------------+
| award_cat_id      | int(11)    | NO   | PRI | NULL    | auto_increment |
| award_cat_name    | mediumtext | YES  |     | NULL    |                |
| award_cat_type_id | int(11)    | YES  |     | NULL    |                |
| award_cat_order   | int(11)    | YES  |     | NULL    |                |
| award_cat_note_id | int(11)    | YES  |     | NULL    |                |
+-------------------+------------+------+-----+---------+----------------+

Description

  • award_cat_id - Unique numeric record ID.
  • award_cat_name - The name of this category, e.g. "Best Novel" or "Best Artist".
  • award_cat_type_id - The ID of the award type associated with this award category. A pointer to the "award_types" table.
  • award_cat_order - A number indicating this category's display order within its award type. "1" is displayed first, "2" is displayed second, etc.
  • award_cat_note_id - The ID of the note associated with this award category. A pointer to the "notes" table.
Retrieved from "http://www.isfdb.org/wiki/index.php/Schema:award_cats"