Schema:pub authors
Jump to navigation
Jump to search
Schema Summary
+-----------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-----------+---------+------+-----+---------+----------------+ | pa_id | int(11) | NO | PRI | NULL | auto_increment | | pub_id | int(11) | YES | MUL | NULL | | | author_id | int(11) | YES | MUL | NULL | | +-----------+---------+------+-----+---------+----------------+
Description
The pub_authors table is a mapping table that links authors to the pubs table.
- pa_id - This column is the unique record id for the pub_authors table.
- author_id - ID of the referred author record.
- pub_id - ID of the referred pubs record.