Difference between revisions of "Schema:notes"
Jump to navigation
Jump to search
(Breaking up larger article) |
|||
| (One intermediate revision by one other user not shown) | |||
| Line 10: | Line 10: | ||
==Description== | ==Description== | ||
| − | The notes table holds free form notes for various records in the database. | + | 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_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. | ||
Latest revision as of 14:56, 28 February 2015
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.