Specimens

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(2 intermediate revisions by one user not shown)
Line 2: Line 2:
  
 
*SpecimenID, integer, 4 bytes, identifier for specimen
 
*SpecimenID, integer, 4 bytes, identifier for specimen
*FileID, integer, 4 bytes, = tblFiles.FileID
+
* [[Files|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)
+
* [[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)
*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
+
* [[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
*DepoCatNo, text, 30 characters maximum, catalogue number of the depository or collection
+
* DepoCatNo, text, 30 characters maximum, catalogue number of the depository or collection
*SpecimenStatusID, integer, 4 bytes, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.)
+
* [[SpecimenStatus|SpecimenStatusID]], integer, 4 bytes, = tblSpecimenStatus.SpecimenStatusID, (OK, damaged, lost, etc.)
*LocalityID, integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality
+
* [[Localities|LocalityID]], integer, 4 bytes, = tblLocalities.LocalityID, identifier for the locality
*CollectEventID, integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event
+
* [[CollectEvents|CollectEventID]], integer, 4 bytes, = tblCollectEvents.CollectEventID, identifier for the collecting event
*DataFlags, integer, 1 byte, bit flags for kinds of data available
+
* DataFlags, integer, 1 byte, bit flags for kinds of data available
**1 = ecological relationship
+
** 1 = ecological relationship
**2 = character data, not yet implemented
+
** 2 = character data, not yet implemented
**4 = image
+
** 4 = image
**8 = sound
+
** 8 = sound
**16 = include specimen locality in maps
+
** 16 = include specimen locality in maps
**32 = image of specimen label
+
** 32 = image of specimen label
*SourceID, integer, 4 bytes, = tblSources.SourceID, source for the data in this table
+
* [[Sources|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
 
*Note, text, 500 characters maximum, condition of specimen or any other information
*AccessCode, integer, 4 bytes, = tblAccessCodes.AccessCode
+
* [[Access_codes|AccessCode]], integer, 4 bytes, = tblAccessCodes.AccessCode
*PreparationType, text, 500 characters maximum, information about specimen preparation
+
* PreparationType, text, 500 characters maximum, information about specimen preparation
*BasisOfRecord, integer, 4 bytes
+
* BasisOfRecord, integer, 4 bytes
**0 = 'Not specified'
+
** 0 = 'Not specified'
**1 = 'Preserved specimen'
+
** 1 = 'Preserved specimen'
**2 = 'Fossil specimen'
+
** 2 = 'Fossil specimen'
**3 = 'Image (still or video)'
+
** 3 = 'Image (still or video)'
**4 = 'Audio recording'
+
** 4 = 'Audio recording'
**5 = 'Checklist/Literature/Map'
+
** 5 = 'Checklist/Literature/Map'
**6 = 'Personal observation'
+
** 6 = 'Personal observation'
*VerbatimLabel, text, 1024 character maximum, full text of specimen label
+
* VerbatimLabel, text, 1024 character maximum, full text of specimen label
*LastUpdate, smalldatetime, date and time row last updated
+
* LastUpdate, smalldatetime, date and time row last updated
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
+
* ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
*CreatedOn, smalldatetime, date and time row was created
+
* CreatedOn, smalldatetime, date and time row was created
*CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
+
* 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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox