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(20) | YES  |     | NULL    |                |
+-----------+-------------+------+-----+---------+----------------+

Description

The pub_content table is a mapping of titles to the publications that contain them. 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.
Personal tools