Schema:webpages

Schema Summary
+---++--+-+-++ | Field        | Type       | Null | Key | Default | Extra          | +---++--+-+-++ | webpage_id   | int(11)    | NO   | PRI | NULL    | auto_increment | | author_id    | int(11)    | YES  |     | NULL    |                | | publisher_id | int(11)    | YES  |     | NULL    |                | | url          | mediumtext | YES  |     | NULL    |                | | pub_series_id | int(11)   | YES  |     | NULL    |                | | title_id     | int(11)    | YES  |     | NULL    |                | +---++--+-+-++

Description
Since an author may have more than one webpage, a webpage table is necessary to map multiple webpages to a single author record.


 * webpage_id - This column is the unique record id for the webpages 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.


 * publisher_id - This column is a foreign key which points to a record in the publishers table.


 * url - This column holds an author webpage address.


 * pub_series_id - This column is a foreign key which points to a record in the pub_series table.


 * title_id - This column is a foreign key which points to a record in the titles table.