Schema:pub content
Jump to navigation
Jump to 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.