Schema:pseudonyms

Schema Summary

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

Description

The pseudonyms table maps pseudonyms back to the actual author.

• pseudo_id - This column is the unique record id for the pseudonyms table. It is the primary key for the table.

• author_id - This column is a foreign key which points to a record in the authors table (the actual author).

• pseudonym - This column is a foreign key which points to a record in the authors table (the pseudonym).