MapCatXState Table

Many to one relationship with the MapCat table. Contains one record for EACH State represented on the image.

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
StateID The identifier code for the state. Cross reference to State table. tinyint 1
RankID The rank describing the geographic scope of Map relative to State. tinyint 1

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


Revised Wednesday September 28 2005