Difference between revisions of "Schema:magazine"
Jump to navigation
Jump to search
(Breaking up larger article) |
(2016 update) |
||
Line 11: | Line 11: | ||
==Description== | ==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''' - | + | * '''Mag_Code''' - Unique prefix for the publication tag normally used for this particular magazine. |
− | * '''Mag_Name''' - | + | * '''Mag_Name''' - Full text title of the magazine. |
− | * '''Mag_Desc''' - | + | * '''Mag_Desc''' - A description of the year range indexed by the ISFDB. |
Latest revision as of 16:53, 3 September 2016
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.