Difference between revisions of "Schema:websites"
Jump to navigation
Jump to search
(Added site_isbn13) |
(→Description: site_isbn13 update) |
||
| Line 18: | Line 18: | ||
* '''site_name''' - Displayed site name. | * '''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_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_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 |
Latest revision as of 13:00, 16 April 2017
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