Schema:reference

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.