Difference between revisions of "Schema:pub series"
Jump to navigation
Jump to search
(New page: ==Schema Summary== +----------------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------...) |
(→Schema Summary: 2016 update) |
||
| Line 5: | Line 5: | ||
+----------------------+------------+------+-----+---------+----------------+ | +----------------------+------------+------+-----+---------+----------------+ | ||
| pub_series_id | int(11) | NO | PRI | NULL | auto_increment | | | pub_series_id | int(11) | NO | PRI | NULL | auto_increment | | ||
| − | | pub_series_name | | + | | pub_series_name | mediumtext | YES | | NULL | | |
| pub_series_wikipedia | mediumtext | YES | | NULL | | | | pub_series_wikipedia | mediumtext | YES | | NULL | | | ||
| pub_series_note_id | int(11) | YES | | NULL | | | | pub_series_note_id | int(11) | YES | | NULL | | | ||
Revision as of 19:44, 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 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.