Difference between revisions of "Schema:notes"
Jump to navigation
Jump to search
(Breaking up larger article) |
|||
Line 10: | Line 10: | ||
==Description== | ==Description== | ||
− | The notes table holds free form notes for various records in the database. Typical usage is for author record biographical information, publication record notes, and title notes. The note columns in the other tables hold an integer value, which is the same as the note key. | + | The notes table holds free form notes for various records in the database. Typical usage is for author record biographical information, publisher notes, publication record notes, and title notes. 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_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. | * '''note_note''' - This column holds the note itself. |
Revision as of 15:43, 1 July 2011
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. Typical usage is for author record biographical information, publisher notes, publication record notes, and title notes. 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.