Difference between revisions of "Schema:reference"
Jump to navigation
Jump to search
(Breaking up larger article) |
(→Description: reference has been relegated to secondary verification use now) |
||
(One intermediate revision by one other user not shown) | |||
Line 13: | Line 13: | ||
==Description== | ==Description== | ||
− | The reference table | + | The reference table contains references used for secondary verification of publication records by ISFDB editors. |
− | * '''reference_id''' - | + | * '''reference_id''' - Unique record id for the reference table. |
* '''reference_label''' - A short label used to refer to this reference. | * '''reference_label''' - A short label used to refer to this reference. | ||
Line 21: | Line 21: | ||
* '''reference_fullname''' - A full text description of the reference. | * '''reference_fullname''' - A full text description of the reference. | ||
− | * '''pub_id''' - | + | * '''pub_id''' - '''Not used'''. |
− | * '''reference_url''' - If the reference has an online description or is an online resource, this | + | * '''reference_url''' - If the reference has an online description or is an online resource, this is the URL of that description/resource. |
Latest revision as of 14:37, 17 April 2017
Schema Summary
+--------------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------------+------------+------+-----+---------+----------------+ | reference_id | int(11) | NO | PRI | NULL | auto_increment | | reference_label | mediumtext | YES | | NULL | | | reference_fullname | mediumtext | YES | | NULL | | | pub_id | int(11) | YES | | 0 | | | reference_url | mediumtext | YES | | NULL | | +--------------------+------------+------+-----+---------+----------------+
Description
The reference table contains references used for secondary verification of publication records by ISFDB editors.
- reference_id - Unique record id for the reference table.
- reference_label - A short label used to refer to this reference.
- reference_fullname - A full text description of the reference.
- pub_id - Not used.
- reference_url - If the reference has an online description or is an online resource, this is the URL of that description/resource.