Schema:publishers

From ISFDB
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-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.