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 and the title record it is a review of. At one point it was envisioned that this table may also be used for series and translation records, which led to the addition of the "series_id" and "translation_id" columns.

• tr_id - This column is the unique record id for the title_relationships table.

• title_id - ID of the title for this relationship. Every entry in this table 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.