Schema:title relationships

From ISFDB

Jump to: navigation, search

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.
Retrieved from "http://www.isfdb.org/wiki/index.php/Schema:title_relationships"
Personal tools