Images (table)

tblImages contains images of specimens and other items.


 * ImageID, integer, 4 bytes, identifier for the image. This is the base portion of the file name.
 * TrueID, integer, 4 bytes, original ImageID for this image content
 * FileID, integer, 4 bytes, = tblFiles.FileID
 * TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID of the species. When a species and subspecies have the same name, use the TaxonNameID of the subspecies.  If TaxonNameID = 0, this image is not associated with any taxon.
 * Status, integer, 1 byte, 0 = normal, 1 = hidden
 * ImageTypeID, integer, 4 bytes, = tblImageTypes.ImageTypeID
 * MIME, integer, 2 bytes, Multipurpose Internet Mail Extension code, = tblMIME.MIMEID. The file extension comes from this, also known as the image file type.
 * 1 = "image/gif"
 * 2 = "image/jpeg"
 * 3 = "image/tiff"
 * 4 = "image/bmp"
 * SexID, integer, 4 bytes, = tblSexes.SexID
 * Description, text, 300 characters maximum
 * SourceID, integer, 4 bytes = tblSources.SourceID
 * Figure, text, 50 characters maximum, figure number or other identification for figures from publications
 * SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID
 * Thumb, data type = OLE object, may be NULL
 * Xsize, integer, 2 bytes
 * Ysize, integer, 2 bytes
 * Image, data type = OLE object, may be NULL
 * AccessCode, integer, 4 bytes
 * LastUpdate, smalldatetime, date and time row last updated
 * ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
 * CreatedOn, smalldatetime, date and time row was created
 * CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row