Schema:notes

Schema Summary

+-----------+------------+------+-----+---------+----------------+
| Field     | Type       | Null | Key | Default | Extra          |
+-----------+------------+------+-----+---------+----------------+
| note_id   | int(11)    | NO   | PRI | NULL    | auto_increment |
| note_note | mediumtext | YES  |     | NULL    |                |
+-----------+------------+------+-----+---------+----------------+

Description

The notes table holds free form notes for various records in the database. Used by the following types of records:

• publisher
• publication
• title
• publication series
• series
• award
• award type
• award category

The note columns in the other tables hold an integer value, which is the same as the note key.

• note_id - This column is the unique record id for the note table. A note may be referred to by this unique id.

• note_note - This column holds the note itself.