MapCatXSubbasin1990 Table

Many to one relationship with the MapCat table. Contains one record for EACH StreamNet subbasin (circa 1990) represented on the plot.

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
Subbasin1990ID Subbasin code defined in 1990 by NPCC smallint 2
RankID The rank describing the geographic scope of Map relative to Subbasin1990. tinyint 1

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


Revised Wednesday September 28 2005