Difference between revisions of "Schema:websites"
Jump to navigation
Jump to search
(New page: ==Schema Summary== +-----------------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------...) |
(Added site_isbn13) |
||
| Line 7: | Line 7: | ||
| site_name | tinytext | YES | | NULL | | | | site_name | tinytext | YES | | NULL | | | ||
| site_url | mediumtext | YES | | NULL | | | | site_url | mediumtext | YES | | NULL | | | ||
| + | | site_isbn13 | tinyint(3) | YES | | NULL | | | ||
+-----------------------+------------+------+-----+---------+----------------+ | +-----------------------+------------+------+-----+---------+----------------+ | ||
| Line 15: | Line 16: | ||
* '''site_id''' - Unique key ID. | * '''site_id''' - Unique key ID. | ||
| − | + | * '''site_name''' - Displayed site name. | |
| − | * '''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. | |
| − | * '''site_url''' - URL of the site | ||
Revision as of 14:53, 28 February 2015
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.