Schema:trans legal names

From ISFDB
Jump to navigation Jump to search

Schema Summary

+---------------------+------------+------+-----+---------+----------------+
| Field               | Type       | Null | Key | Default | Extra          |
+---------------------+------------+------+-----+---------+----------------+
| trans_legal_name_id | int(11)    | NO   | PRI | NULL    | auto_increment |
| trans_legal_name    | mediumtext | YES  |     | NULL    |                |
| author_id           | int(11)    | YES  | MUL | NULL    |                |
+---------------------+------------+------+-----+---------+----------------+

Description

The trans_authors table stores transliterated versions of authors' legals names.

  • trans_legal_name_id - Unique record id for the trans_legal_names table.
  • trans_legal_name - Transliterated legal name.
  • author_id - ID of the author. Points to the "authors" table.