Schema:publishers

Schema Summary

+---------------------+-------------+------+-----+---------+----------------+
| Field               | Type        | Null | Key | Default | Extra          |
+---------------------+-------------+------+-----+---------+----------------+
| publisher_id        | int(11)     | NO   | PRI | NULL    | auto_increment |
| publisher_name      | varchar(64) | YES  |     | NULL    |                |
| publisher_wikipedia | mediumtext  | YES  |     | NULL    |                |
| note_id             | int(11)     | YES  |     | NULL    |                |
+---------------------+-------------+------+-----+---------+----------------+

Description

The publishers table contains publisher-related information. It is referred to by the pubs table.

• publisher_id - This column is the unique record id for the publishers table.

• publisher_name - This column holds the publisher's name.

• publisher_wikipedia - This column holds the URL to a Wikipedia article.

• note_id - This column contains an integer value which refers to the ID of a record found in the notes table.