Schema:notes
Jump to navigation
Jump to search
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.