Schema:magazine

From ISFDB

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

(Note: This table is for future use, but is not currently used) The magazine table holds metadata for a complete run of a particular magazine.

• Mag_Code - This is the unique prefix for the publication tag normally used for this particular magazine.

• Mag_Name - This is the full text title of the magazine.

• Mag_Desc - This column holds a description of the year range indexed by the ISFDB.