Specimens

From Species File Help
Revision as of 11:38, 27 August 2012 by Maehr (Talk | contribs)

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

tblSpecimens contains information about specimens.

   SpecimenID, integer, 4 bytes, identifier for specimen
   TaxonNameID, integer, 4 bytes, = tblTaxon.TaxonNameID of a valid or unnamed taxon that is the current identification (may be higher level taxon if not identified further)
   DepoID, integer, 2 bytes, = tblDepos.DepoID, identifier for depository or collection that owns the specimen, a negative value means that the depository is not certain
   DepoCatNo, text, 30 bytes maximum, catalogue number of the depository or collection
   PreparationCode, integer, 1 byte, 0 = unspecified, 1 = pin, 2 = vial, 3 = jar, 4 = alcohol (vial or jar not specified), 5 = microscope slide dropped in version 4.0
   MaleCount, integer, 2 bytes, number of adult males (-1 means "many", -2 means "more than 1") dropped in version 4.0
   FemaleCount, integer, 2 bytes, number of adult females (-1 means "many", -2 means "more than 1") dropped in version 4.0
   UnsexedAdultCount, integer, 2 bytes, number of unsexed adults (-1 means "many", -2 means "more than 1") dropped in version 4.0
   ImmatureCount, integer, 2 bytes, number of juveniles (-1 means "many", -2 means "more than 1") dropped in version 4.0
   SpecimenStatusID, integer, 1 byte, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.)
   LocalityID, integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality
   CollectEventID, integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event
   DataFlags, integer, 1 byte, bit flags for kinds of data available
       1 = ecological relationship
       2 = character data, not yet implemented
       4 = image
       8 = sound
       16 = include specimen locality in maps, implemented in version 3.5
   SourceID, integer, 2 bytes, = tblSources.SourceID, source for the data in this table
   Note, text, 300 bytes maximum, condition of specimen or any other information
   AccessCode, integer, 2 bytes
   LastUpdate, smalldatetime, date and time of last update
   ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
   PreparationType, text, 300 byte maximum, text field replacing PreparationCode, added in version 4.0
   BasisOfRecord, integer, 4 bytes, added in version 4.0
       0 = 'Not specified'
       1 = 'Preserved specimen'
       2 = 'Fossil specimen'
       3 = 'Image (still or video)'
       4 = 'Audio recording'
       5 = 'Checklist/Literature/Map'
       6 = 'Personal observation'
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox