Difference between revisions of "Schema:title awards"

From ISFDB
Jump to navigation Jump to search
(Breaking up larger article)
(No difference)

Revision as of 22:13, 22 May 2008

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.