Specimens

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
'''tblSpecimens''' contains information about specimens.
 
'''tblSpecimens''' contains information about specimens.
  
−
    SpecimenID, integer, 4 bytes, identifier for specimen
+
*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)
+
* [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID
−
    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
+
* [[Taxa|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)
−
    DepoCatNo, text, 30 bytes maximum, catalogue number of the depository or collection
+
* [[Depos|DepoID]], integer, 4 bytes, = tblDepos.DepoID, identifier for depository or collection that owns the specimen, a negative value means that the depository is not certain
−
    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
+
* DepoCatNo, text, 30 characters maximum, catalogue number of the depository or collection
−
    MaleCount, integer, 2 bytes, number of adult males (-1 means "many", -2 means "more than 1") dropped in version 4.0
+
* [[SpecimenStatus|SpecimenStatusID]], integer, 4 bytes, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.)
−
    FemaleCount, integer, 2 bytes, number of adult females (-1 means "many", -2 means "more than 1") dropped in version 4.0
+
* [[Localities|LocalityID]], integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality
−
    UnsexedAdultCount, integer, 2 bytes, number of unsexed adults (-1 means "many", -2 means "more than 1") dropped in version 4.0
+
* [[CollectEvents|CollectEventID]], integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event
−
    ImmatureCount, integer, 2 bytes, number of juveniles (-1 means "many", -2 means "more than 1") dropped in version 4.0
+
* DataFlags, integer, 1 byte, bit flags for kinds of data available
−
    SpecimenStatusID, integer, 1 byte, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.)
+
** 1 = ecological relationship
−
    LocalityID, integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality
+
** 2 = character data, not yet implemented
−
    CollectEventID, integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event
+
** 4 = image
−
    DataFlags, integer, 1 byte, bit flags for kinds of data available
+
** 8 = sound
−
        1 = ecological relationship
+
** 16 = include specimen locality in maps
−
        2 = character data, not yet implemented
+
** 32 = image of specimen label
−
        4 = image
+
* [[Sources|SourceID]], integer, 4 bytes, = tblSources.SourceID, source for the data in this table
−
        8 = sound
+
*Note, text, 500 characters maximum, condition of specimen or any other information
−
        16 = include specimen locality in maps, implemented in version 3.5
+
* [[Access_codes|AccessCode]], integer, 4 bytes, = tblAccessCodes.AccessCode
−
    SourceID, integer, 2 bytes, = tblSources.SourceID, source for the data in this table
+
* PreparationType, text, 500 characters maximum, information about specimen preparation
−
    Note, text, 300 bytes maximum, condition of specimen or any other information
+
* BasisOfRecord, integer, 4 bytes
−
    AccessCode, integer, 2 bytes
+
** 0 = 'Not specified'
−
    LastUpdate, smalldatetime, date and time of last update
+
** 1 = 'Preserved specimen'
−
    ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
+
** 2 = 'Fossil specimen'
−
    PreparationType, text, 300 byte maximum, text field replacing PreparationCode, added in version 4.0
+
** 3 = 'Image (still or video)'
−
    BasisOfRecord, integer, 4 bytes, added in version 4.0
+
** 4 = 'Audio recording'
−
        0 = 'Not specified'
+
** 5 = 'Checklist/Literature/Map'
−
        1 = 'Preserved specimen'
+
** 6 = 'Personal observation'
−
        2 = 'Fossil specimen'
+
* VerbatimLabel, text, 1024 character maximum, full text of specimen label
−
        3 = 'Image (still or video)'
+
* LastUpdate, smalldatetime, date and time row last updated
−
        4 = 'Audio recording'
+
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
−
        5 = 'Checklist/Literature/Map'
+
* CreatedOn, smalldatetime, date and time row was created
−
        6 = 'Personal observation'
+
* CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]
 +
[[Category:Tables]]

Latest revision as of 16:48, 11 September 2012

tblSpecimens contains information about specimens.

  • SpecimenID, integer, 4 bytes, identifier for specimen
  • FileID, integer, 4 bytes, = tblFiles.FileID
  • 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, 4 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 characters maximum, catalogue number of the depository or collection
  • SpecimenStatusID, integer, 4 bytes, = 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
    • 32 = image of specimen label
  • SourceID, integer, 4 bytes, = tblSources.SourceID, source for the data in this table
  • Note, text, 500 characters maximum, condition of specimen or any other information
  • AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode
  • PreparationType, text, 500 characters maximum, information about specimen preparation
  • BasisOfRecord, integer, 4 bytes
    • 0 = 'Not specified'
    • 1 = 'Preserved specimen'
    • 2 = 'Fossil specimen'
    • 3 = 'Image (still or video)'
    • 4 = 'Audio recording'
    • 5 = 'Checklist/Literature/Map'
    • 6 = 'Personal observation'
  • VerbatimLabel, text, 1024 character maximum, full text of specimen label
  • 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
Retrieved from "http://help.speciesfile.org/index.php?title=Specimens&oldid=1016"
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox