Schema:websites

From ISFDB
Revision as of 14:38, 1 July 2011 by BLongley (talk | contribs) (New page: ==Schema Summary== +-----------------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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    |                |
+-----------------------+------------+------+-----+---------+----------------+


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 - A short site name.
  • site_url - URL of the site and required parameters.