Difference between revisions of "Schema:title awards"

From ISFDB
Jump to navigation Jump to search
(Breaking up larger article)
 
(→‎Description: 2016 update and cleanup)
 
Line 11: Line 11:
 
==Description==
 
==Description==
  
The title_awards table maps an award to a title listed in the titles table.
+
The title_awards table links title-based awards to their associated title records.
  
* '''taw_id''' - This column is the unique record id for the title_awards table.
+
* '''taw_id''' - 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.
+
* '''award_id''' - ID of a record in the awards table.
  
* '''title_id''' - This column contains an integer value which refers to the ID of a record found in the titles table.
+
* '''title_id''' - ID of a record in the titles table.

Latest revision as of 17:16, 3 September 2016

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 links title-based awards to their associated title records.

  • taw_id - Unique record id for the title_awards table.
  • award_id - ID of a record in the awards table.
  • title_id - ID of a record in the titles table.