Schema:pubs

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(16)                           | YES  |     | NULL    |                |
| pub_ptype      | varchar(32)                           | YES  |     | NULL    |                |
| pub_ctype      | enum('ANTHOLOGY','CHAPTERBOOK',       |      |     |         |                |
|                |      'COLLECTION','MAGAZINE',         |      |     |         |                |
|                |      'NONFICTION','NOVEL',            |      |     |         |                |
|                |      'OMNIBUS','FANZINE')             | YES  |     | NULL    |                |
| pub_isbn       | varchar(32)                           | YES  |     | NULL    |                |
| pub_frontimage | mediumtext                            | YES  |     | NULL    |                |
| pub_price      | varchar(16)                           | YES  |     | NULL    |                |
| note_id        | int(11)                               | YES  |     | NULL    |                |
| pub_series_id  | int(11)                               | YES  |     | NULL    |                |
| pub_series_num | varchar(64)                           | YES  |     | NULL    |                |
+----------------+---------------------------------------+------+-----+---------+----------------+

Description

The pubs table directly replicates the old ISFDB pubs record format (BOOKS/ZINES, pubs.dbase).

• pub_id - This column is the unique record id for the pubs table. A title may be referred to by this unique id.

• pub_title - This column holds the working title.

• pub_tag - This column holds a unique ascii tag for the publication.

• pub_year - This column contains the publication date of the publication.

• publisher_id - This column contains an integer value which refers to the ID of a record found in the publishers table.

• pub_pages - This column holds the page count of the publication.

• pub_ptype - This column holds publication binding type.
  • hc = hardcover
  • pb = paperback
  • ph = pamphlet
  • tp = trade

(NOTE: This should be an ennumerated type)

• pub_ctype - This column holds the database type of the publication.

• pub_isbn - This column holds the publication's ISBN-10 or ISBN-13 value, or a Catalog Number. Some Magazines may have an ISSN here.

• pub_frontimage - This column holds a URL to an online image of the cover.

• pub_price - This column holds the price of the publication. Main price only, others go in notes.

• note_id - This column contains an integer value which refers to the ID of a record found in the notes table.

• pub_series_id - This column contains an integer value which refers to the ID of a record found in the pub_series table.

• pub_series_num - This column contains a value which refers to a publication series position.