Schema:publishers

From ISFDB

Revision as of 00:29, 23 May 2008 by Alvonruff (Talk | contribs)
(diff) ←Older revision | Current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

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.
Personal tools