Difference between revisions of "Schema:publishers"

From ISFDB
Jump to navigation Jump to search
(Breaking up larger article)
 
(→‎Description: 2016 update)
 
Line 12: Line 12:
 
==Description==
 
==Description==
  
The publishers table contains publisher-related information. It is referred to by the pubs table.
+
The publishers table contains publisher-specific information.
  
* '''publisher_id''' - This column is the unique record id for the publishers table.
+
* '''publisher_id''' - Unique record id for the publishers table.
  
* '''publisher_name''' - This column holds the publisher's name.
+
* '''publisher_name''' - The publisher's name.
  
* '''publisher_wikipedia''' - This column holds the URL to a Wikipedia article.
+
* '''publisher_wikipedia''' - URL to a Wikipedia article. '''No longer used'''.
  
* '''note_id''' - This column contains an integer value which refers to the ID of a record found in the notes table.
+
* '''note_id''' - ID of the note record about this publisher in the "notes" table.

Latest revision as of 19:48, 3 September 2016

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-specific information.

  • publisher_id - Unique record id for the publishers table.
  • publisher_name - The publisher's name.
  • publisher_wikipedia - URL to a Wikipedia article. No longer used.
  • note_id - ID of the note record about this publisher in the "notes" table.