Images (table)

From Species File Help
Revision as of 10:43, 30 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox