Difference between revisions of "Schema:pub series"
Jump to navigation
Jump to search
(→Schema Summary: 2016 update) |
(→Description: 2016 update) |
||
| Line 12: | Line 12: | ||
==Description== | ==Description== | ||
| − | The pub_series table | + | The pub_series table stored data about publication series -- see [[Help:Screen:PublicationSeries]] for details. |
| − | * '''pub_series_id''' - | + | * '''pub_series_id''' - Unique record id for the pub_series table. |
| − | * '''pub_series_name''' - | + | * '''pub_series_name''' - The name of the publication series. |
| − | * '''pub_series_wikipedia''' - | + | * '''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. | + | * '''pub_series_note_id''' - Foreign key to a notes entry about the series in the "notes" table. |
Latest revision as of 19:46, 3 September 2016
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.