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.