Schema:pub authors

From ISFDB

Jump to: navigation, 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.
Personal tools