Schema:pub series

Schema Summary

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

Description

The pub_series table records sets of publications that have something in common, that can't be represented by title series.

• pub_series_id - This column is the unique record id for the pub_series table.

• pub_series_name - This column stores a name for the pub_series.

• pub_series_wikipedia - This column can contain the URL of a Wikipedia page about the series.

• pub_series_note_id - Foreign key to a notes entry about the series.