Images (table)
From Species File Help
(Difference between revisions)
(created page) |
(cat) |
||
Line 28: | Line 28: | ||
[[Category:ImgSndEcoTables]] | [[Category:ImgSndEcoTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 15:56, 8 September 2012
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