Schema:trans authors

Schema Summary

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

Description

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

• trans_author_id - Unique record id for the trans_authors table.

• trans_author_name - Transliterated author name.

• author_id - ID of the author. Points to the "authors" table.