Schema:trans publisher

From ISFDB
Jump to navigation Jump to search

Schema Summary

+----------------------+------------+------+-----+---------+----------------+
| Field                | Type       | Null | Key | Default | Extra          |
+----------------------+------------+------+-----+---------+----------------+
| trans_publisher_id   | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_publisher_name | mediumtext | YES  |     | NULL    |                |
| publisher_id         | int(11)    | YES  | MUL | NULL    |                |
+----------------------+------------+------+-----+---------+----------------+

Description

The trans_publisher table stores transliterated versions of publisher names.

  • trans_publisher_id - Unique record id for the trans_publisher table.
  • trans_publisher_name - Transliterated publisher name.
  • publisher_id - ID of the publisher. Points to the "publishers" table.