Schema:publishers

From ISFDB
Jump to navigation Jump to 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-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.