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.