Schema:trans titles

From ISFDB
Jump to navigation Jump to search

Schema Summary

+-------------------+------------+------+-----+---------+----------------+
| Field             | Type       | Null | Key | Default | Extra          |
+-------------------+------------+------+-----+---------+----------------+
| trans_title_id    | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_title_title | mediumtext | YES  | MUL | NULL    |                |
| title_id          | int(11)    | YES  | MUL | NULL    |                |
+-------------------+------------+------+-----+---------+----------------+

Description

The trans_titles table stores transliterated versions of title (work) titles.

  • trans_title_id - Unique record id for the trans_titles table.
  • trans_title_title - Transliterated title (work) title.
  • title_id - ID of the title. Points to the "titles" table.