Schema:trans pub series

From ISFDB
Jump to navigation Jump to search

Schema Summary

+-----------------------+------------+------+-----+---------+----------------+
| Field                 | Type       | Null | Key | Default | Extra          |
+-----------------------+------------+------+-----+---------+----------------+
| trans_pub_series_id   | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_pub_series_name | mediumtext | YES  |     | NULL    |                |
| pub_series_id         | int(11)    | YES  | MUL | NULL    |                |
+-----------------------+------------+------+-----+---------+----------------+

Description

The trans_pub_series table stores transliterated versions of publication series names.

  • trans_pub_series_id - Unique record id for the trans_pub_series table.
  • trans_pub_series_name - Transliterated publication series name.
  • pub_series_id - ID of the publication series. Points to the "pub_series" table.