MapCatXProvince Table

Many to one relationship with the MapCat table. Contains one record for EACH NWPPC Province represented on the image for drainage specific images ONLY.

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
ProvinceID Province code defined by NWPPC in 2001 tinyint 1
RankID The rank describing the geographic scope of Map relative to Province. tinyint 1

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


Revised Wednesday September 28 2005