Schema:webpages

Schema Summary

+---------------+------------+------+-----+---------+----------------+
| Field         | Type       | Null | Key | Default | Extra          |
+---------------+------------+------+-----+---------+----------------+
| webpage_id    | int(11)    | NO   | PRI | NULL    | auto_increment |
| author_id     | int(11)    | YES  | MUL | NULL    |                |
| publisher_id  | int(11)    | YES  | MUL | NULL    |                |
| url           | mediumtext | YES  |     | NULL    |                |
| pub_series_id | int(11)    | YES  | MUL | NULL    |                |
| title_id      | int(11)    | YES  | MUL | NULL    |                |
| award_type_id | int(11)    | YES  | MUL | NULL    |                |
| series_id     | int(11)    | YES  | MUL | NULL    |                |
| award_cat_id  | int(11)    | YES  | MUL | NULL    |                |
| pub_id        | int(11)    | YES  | MUL | 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.

• award_type_id - This column is a foreign key which points to a record in the award type table.

• series_id - This column is a foreign key which points to a record in the series table.

• award_cat_id - This column is a foreign key which points to a record in the award category table.

• pub_id - This column is a foreign key which points to a record in the publication table.