MapCatXDam Table

Many to one relationship with the MapCat table. Contains one record for EACH dam 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
DamID The dam ID, foreign key to table Dam int 4
RankID The rank describing the geographic scope of Map relative to the Dam. tinyint 1

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


Revised Wednesday September 28 2005