Schema:publishers

From ISFDB
Revision as of 20:29, 22 May 2008 by Alvonruff (talk | contribs) (Breaking up larger article)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Schema Summary

+---------------------+-------------+------+-----+---------+----------------+
| Field               | Type        | Null | Key | Default | Extra          |
+---------------------+-------------+------+-----+---------+----------------+
| publisher_id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| publisher_name      | varchar(64) | YES  |     | NULL    |                |
| publisher_wikipedia | mediumtext  | YES  |     | NULL    |                |
| note_id             | int(11)     | YES  |     | NULL    |                |
+---------------------+-------------+------+-----+---------+----------------+

Description

The publishers table contains publisher-related information. It is referred to by the pubs table.

  • publisher_id - This column is the unique record id for the publishers table.
  • publisher_name - This column holds the publisher's name.
  • publisher_wikipedia - This column holds the URL to a Wikipedia article.
  • note_id - This column contains an integer value which refers to the ID of a record found in the notes table.