Schema:award types

From ISFDB
Revision as of 15:02, 1 July 2011 by BLongley (talk | contribs) (New page: ==Schema Summary== +--------------+------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+---------...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Schema Summary

+--------------+------------+------+-----+---------+----------------+
| Field        | Type       | Null | Key | Default | Extra          |
+--------------+------------+------+-----+---------+----------------+
| code         | varchar(2) | NO   | PRI |         |                | 
| name         | mediumtext | YES  |     |         |                |  
+--------------+------------+------+-----+---------+----------------+

Description

Not yet implemented and subject to change. Designed to replace hard-coded award_ttypes.

  • code - This column holds a two-letter award code.
  • name - This column holds an ASCII plain-text description of the award.