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 holds the officially recognized references used to verify publication records.

• reference_id - This column is the 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 - If the reference has been documented in the ISFDB, this field points to the publication record.

• reference_url - If the reference has an online description or is an online resource, this field points to the URL.