Schema:emails

Schema Summary

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

Description

Since an author may have more than one email address, an emails table is necessary to map multiple addresses to a single author record.

• email_id - This column is the unique record id for the emails 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.

• email_address - This column holds an author email address.