Specimens
From Species File Help
(Difference between revisions)
(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