Difference between revisions of "Schema:title relationships"
Jump to navigation
Jump to search
(New Page) |
(→Description: Fixed description) |
||
Line 13: | Line 13: | ||
==Description== | ==Description== | ||
− | The | + | The title relationships table creates a relationship between a review title, series title, or translation title to the title record it is a review, series, or translation of. |
* '''tr_id''' - This column is the unique record id for the title_relationships table. | * '''tr_id''' - This column is the unique record id for the title_relationships table. |
Revision as of 08:32, 24 May 2008
Schema Summary
+----------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------+------+-----+---------+----------------+ | tr_id | int(11) | NO | PRI | NULL | auto_increment | | title_id | int(11) | YES | MUL | NULL | | | review_id | int(11) | YES | MUL | NULL | | | series_id | int(11) | YES | MUL | NULL | | | translation_id | int(11) | YES | MUL | NULL | | +----------------+---------+------+-----+---------+----------------+
Description
The title relationships table creates a relationship between a review title, series title, or translation title to the title record it is a review, series, or translation of.
- tr_id - This column is the unique record id for the title_relationships table.
- title_id - A relationship is made to this title. Every entry must have a title_id.
- review_id - A review which reviews title_id.
- series_id - A title which serializes title_id.
- translation_id - A translation of title_id.