Schema:magazine

Schema Summary

+----------+--------------+------+-----+---------+-------+
| Field    | Type         | Null | Key | Default | Extra |
+----------+--------------+------+-----+---------+-------+
| Mag_Code | varchar(16)  | NO   | PRI |         |       |
| Mag_Name | varchar(50)  | NO   |     |         |       |
| Mag_Desc | varchar(100) | YES  |     | NULL    |       |
+----------+--------------+------+-----+---------+-------+

Description

The magazine table was supposed to hold metadata for a complete run of a particular magazine. It has never been used and there are no plans to use it in the future.

• Mag_Code - Unique prefix for the publication tag normally used for this particular magazine.

• Mag_Name - Full text title of the magazine.

• Mag_Desc - A description of the year range indexed by the ISFDB.