Difference between revisions of "Schema:publishers"
Jump to navigation
Jump to search
(Breaking up larger article) |
(→Description: 2016 update) |
||
Line 12: | Line 12: | ||
==Description== | ==Description== | ||
− | The publishers table contains publisher- | + | The publishers table contains publisher-specific information. |
− | * '''publisher_id''' - | + | * '''publisher_id''' - Unique record id for the publishers table. |
− | * '''publisher_name''' - | + | * '''publisher_name''' - The publisher's name. |
− | * '''publisher_wikipedia''' - | + | * '''publisher_wikipedia''' - URL to a Wikipedia article. '''No longer used'''. |
− | * '''note_id''' - | + | * '''note_id''' - ID of the note record about this publisher in the "notes" table. |
Latest revision as of 19:48, 3 September 2016
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-specific information.
- publisher_id - Unique record id for the publishers table.
- publisher_name - The publisher's name.
- publisher_wikipedia - URL to a Wikipedia article. No longer used.
- note_id - ID of the note record about this publisher in the "notes" table.