Schema:pub series

From ISFDB
Revision as of 19:46, 3 September 2016 by Ahasuerus (talk | contribs) (→‎Description: 2016 update)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Schema Summary

+----------------------+------------+------+-----+---------+----------------+
| Field                | Type       | Null | Key | Default | Extra          |
+----------------------+------------+------+-----+---------+----------------+
| pub_series_id        | int(11)    | NO   | PRI | NULL    | auto_increment |
| pub_series_name      | mediumtext | YES  |     | NULL    |                |
| pub_series_wikipedia | mediumtext | YES  |     | NULL    |                |
| pub_series_note_id   | int(11)    | YES  |     | NULL    |                |
+----------------------+------------+------+-----+---------+----------------+

Description

The pub_series table stored data about publication series -- see Help:Screen:PublicationSeries for details.

  • pub_series_id - Unique record id for the pub_series table.
  • pub_series_name - The name of the publication series.
  • pub_series_wikipedia - URL of a Wikipedia page about the series. No longer used.
  • pub_series_note_id - Foreign key to a notes entry about the series in the "notes" table.