MapCatXHatchery Table

Many to one relationship with the MapCat table. Contains one record for EACH hatchery that appears on the map.

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
HatchID The hatch (ery) ID, foreign key to table Hatchery smallint 2
RankID The rank describing the geographic scope of Map relative to Hatchery. tinyint 1

*The text datatype pre-allocates only 16 bytes. Size represents actual bytes for all other data types.


Revised Wednesday September 28 2005