Schema:pub authors
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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.