SpecimenStatus

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(cat)
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
'''tblSpecimenStatus''' contains sex and maturity classification for specimens, shared across files.
+
'''tblSpecimenStatus''' contains lost, lost?, missing, missing?, etc.
  
    SpecimenStatusID, integer, 1 byte, identifier for the status
+
*SpecimenStatusID, integer, 4 bytes, identifier for the status
    Status, text, 20 characters maximum
+
*Status, text, 20 characters maximum
        0 = presumed OK
+
**0 = presumed OK
        1 = missing
+
**1 = missing
        2 = destroyed
+
**2 = destroyed
        3 = lost
+
**3 = lost
        4 = unknown
+
**4 = unknown
        5 = missing?
+
**5 = missing?
        6 = destroyed?
+
**6 = destroyed?
        7 = lost?
+
**7 = lost?
        8 = damaged
+
**8 = damaged
        9 = damaged?
+
**9 = damaged?
        10 = no data entered
+
**10 = no data entered
  
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]
 +
[[Category:Tables]]

Latest revision as of 10:05, 9 September 2012

tblSpecimenStatus contains lost, lost?, missing, missing?, etc.

  • SpecimenStatusID, integer, 4 bytes, identifier for the status
  • Status, text, 20 characters maximum
    • 0 = presumed OK
    • 1 = missing
    • 2 = destroyed
    • 3 = lost
    • 4 = unknown
    • 5 = missing?
    • 6 = destroyed?
    • 7 = lost?
    • 8 = damaged
    • 9 = damaged?
    • 10 = no data entered
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox