Schema:pseudonyms
Jump to navigation
Jump to search
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).