Schema:pub content

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.