Schema:websites

From ISFDB

Jump to: navigation, 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.
Personal tools