Difference between revisions of "Schema:title awards"
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 | + | The title_awards table links title-based awards to their associated title records. |
− | * '''taw_id''' - | + | * '''taw_id''' - Unique record id for the title_awards table. |
− | * '''award_id''' - | + | * '''award_id''' - ID of a record in the awards table. |
− | * '''title_id''' - | + | * '''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.