Schema:pubs
Jump to navigation
Jump to search
Schema Summary
+----------------+---------------------------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------------------------+------+-----+---------+----------------+
| pub_id | int(11) | NO | PRI | NULL | auto_increment |
| pub_title | mediumtext | YES | MUL | NULL | |
| pub_tag | varchar(32) | YES | MUL | NULL | |
| pub_year | date | YES | | NULL | |
| publisher_id | int(11) | YES | | NULL | |
| pub_pages | varchar(100) | YES | | NULL | |
| pub_ptype | varchar(32) | YES | | NULL | |
| pub_ctype | enum('ANTHOLOGY','CHAPBOOK', | | | | |
| | 'COLLECTION','MAGAZINE', | | | | |
| | 'NONFICTION','NOVEL', | | | | |
| | 'OMNIBUS','FANZINE') | YES | | NULL | |
| pub_isbn | varchar(100) | YES | | NULL | |
| pub_frontimage | mediumtext | YES | | NULL | |
| pub_price | varchar(100) | YES | | NULL | |
| note_id | int(11) | YES | MUL | NULL | |
| pub_series_id | int(11) | YES | | NULL | |
| pub_series_num | varchar(64) | YES | | NULL | |
| pub_catalog | mediumtext | YES | | NULL | |
+----------------+---------------------------------------+------+-----+---------+----------------+
Description
The pubs table stores information about publication records.
- pub_id - Unique record id for the pubs table.
- pub_title - The title of this publication.
- pub_tag - A unique tag for the publication. Note that the use of publication-specific tags has been deprecated. You can still use them in publication page URLs and when linking from publications to Wiki pages, but this functionality is expected to go away in the future. Publication tags are not to be confused with title tags, which are stored in the "tags" table.
- pub_year - The publication date of the publication.
- publisher_id - ID of this publication's publisher found in the "publishers" table.
- pub_pages - The page count of the publication.
- pub_ptype - Publication binding type. The database definition supports arbitrary values to to 32 characters in length, but the software will only let editors enter the values stored in the global variable BINDINGS in the common/isfdb.py module.
- pub_ctype - Type of the publication. Supports the enumerated values listed in the database definition.
- pub_isbn - The publication's ISBN-10 or ISBN-13 value.
- pub_frontimage - URL of an online image of the cover. If a pipe character ("|") is present, then everything before it is the URL of the image and everything after it is the URL of the Web page that the ISFDB software will link to when the image is clicked.
- pub_price - The price of the publication. Main price only, other prices are entered in notes.
- note_id - ID of this publication's note record found in the "notes" table.
- pub_series_id - ID of this publication's publication series record found in the "pub_series" table.
- pub_series_num - This publication number within its publication series.
- catalog_id - This publication's Catalog ID if present.