SpecimenCounts

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(added content)
Line 1: Line 1:
'''tblSpecimenCounts''' contains counts for various specimen categories added in version 4.0.
+
'''tblSpecimenCounts''' contains counts for various specimen categories.
 
+
    SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
+
    SpmnCategoryID, integer, 2 bytes, identifier for the category
+
    Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1")
+
    LastUpdate, smalldatetime, date and time of last update
+
    ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
+
  
 +
*SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
 +
*SpmnCategoryID, integer, 4 bytes, identifier for the category
 +
*Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1")
 +
*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
 +
   
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]

Revision as of 10:38, 29 August 2012

tblSpecimenCounts contains counts for various specimen categories.

  • SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
  • SpmnCategoryID, integer, 4 bytes, identifier for the category
  • Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1")
  • 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