Schema:pub content

From ISFDB

Jump to: navigation, search

Schema Summary

+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| pubc_id   | int(11)    | NO   | PRI | NULL    | auto_increment |
| title_id  | int(11)    | YES  | MUL | NULL    |                |
| pub_id    | int(11)    | YES  | MUL | NULL    |                |
| pubc_page | varchar(8) | YES  |     | NULL    |                |
+-----------+------------+------+-----+---------+----------------+

Description

The pub_content table contains a particular instantiation of a title as it appeared in a publication; future versions of the table will include columns for variant titles, authors, and page numbers. It also serves as a normalization table to map a publication record to a title record. The table includes indexes for both the title_id and pub_id columns.

  • pubc_id - This column is the unique record id for the pub_content table.
  • title_id - This column is a foreign key which points to a title record.
  • pub_id - This column is a foreign key which points to a publication record.
  • pubc_page - Page number in the referred publication upon which the referred title appears.
Retrieved from "http://www.isfdb.org/wiki/index.php/Schema:pub_content"
Personal tools