MapCatXSpecieRun Table

Many to one relationship with the MapCat table. Contains one record for EACH species/run combination represented on the image (if applicable).

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
SpecieID The species ID. Cross reference to the Specie table. smallint 2
RunId The run ID. Cross reference to Run table. tinyint 1

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


Revised Wednesday September 28 2005