Schema:trans series

From ISFDB
Jump to navigation Jump to search

Schema Summary

+-----------------------+------------+------+-----+---------+----------------+
| Field                 | Type       | Null | Key | Default | Extra          |
+-----------------------+------------+------+-----+---------+----------------+
| trans_series_id       | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_series_name     | mediumtext | YES  |     | NULL    |                |
| series_id             | int(11)    | YES  | MUL | NULL    |                |
+-----------------------+------------+------+-----+---------+----------------+

Description

The trans_series table stores transliterated versions of series names.

  • trans_series_id - Unique record id for the trans_series table.
  • trans_series_name - Transliterated series name.
  • series_id - ID of the series. Points to the "series" table.