MapCatXFormat Table

Many to one relationship with the MapCat table. Contains one record for EACH format a particular plot is available in.

Field Name Field Description Data Type Field Size*
MapID The map or image ID, foreign key to table MapCat int 4
FormatID The format ID, foreign key to table MapFormat tinyint 1
Filename The filename of the image file varchar 50
Resolution The pixel resolution of the image varchar 50
Size The size of the file in bytes int 4
DisplayDefault A logical field used to set the default field for display on the internet system when multiple sizes of an image are available char 1

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


Revised Wednesday September 28 2005