Schema:title relationships

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. Currently Unused.

• translation_id - A translation of title_id. Currently Unused.