Schema:title awards

From ISFDB
Revision as of 22:13, 22 May 2008 by Alvonruff (talk | contribs) (Breaking up larger article)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Schema Summary

+----------+---------+------+-----+---------+----------------+
| Field    | Type    | Null | Key | Default | Extra          |
+----------+---------+------+-----+---------+----------------+
| taw_id   | int(11) | NO   | PRI | NULL    | auto_increment |
| award_id | int(11) | YES  | MUL | NULL    |                |
| title_id | int(11) | YES  | MUL | NULL    |                |
+----------+---------+------+-----+---------+----------------+

Description

The title_awards table maps an award to a title listed in the titles table.

  • taw_id - This column is the unique record id for the title_awards table.
  • award_id - This column contains an integer value which refers to the ID of a record found in the awardss table.
  • title_id - This column contains an integer value which refers to the ID of a record found in the titles table.