Schema:trans pubs

From ISFDB
Jump to navigation Jump to search

Schema Summary

+-----------------+------------+------+-----+---------+----------------+
| Field           | Type       | Null | Key | Default | Extra          |
+-----------------+------------+------+-----+---------+----------------+
| trans_pub_id    | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_pub_title | mediumtext | YES  | MUL | NULL    |                |
| pub_id          | int(11)    | YES  | MUL | NULL    |                |
+-----------------+------------+------+-----+---------+----------------+

Description

The trans_pubs table stores transliterated versions of publication titles.

  • trans_pub_id - Unique record id for the trans_pubs table.
  • trans_pub_title - Transliterated publication title.
  • pub_id - ID of the publication. Points to the "pubs" table.