Schema:websites

Schema Summary

+-----------------------+------------+------+-----+---------+----------------+
| Field                 | Type       | Null | Key | Default | Extra          |
+-----------------------+------------+------+-----+---------+----------------+
| site_id               | int(11)    | NO   | PRI | NULL    | auto_increment |
| site_name             | tinytext   | YES  |     | NULL    |                |
| site_url              | mediumtext | YES  |     | NULL    |                |
| site_isbn13           | tinyint(3) | YES  |     | NULL    |                |
+-----------------------+------------+------+-----+---------+----------------+

Description

The websites table is used to store bookseller and bibliographic sites that a publication may link to.

• site_id - Unique key ID.
• site_name - Displayed site name.
• site_url - URL of the site. The book's ISBN should be entered as "%s" so that it could be replaced with the actual ISBN at display time.
• site_isbn13 - 1 if the site requires an ISBN-13 to link to it, NULL if it requires an ISBN-10, 2 if it requires the ISBN format that appears in the book