SpecimenCounts

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m
 
Line 1: Line 1:
 
'''tblSpecimenCounts''' contains counts for various specimen categories.
 
'''tblSpecimenCounts''' contains counts for various specimen categories.
  
* [[Specimen|SpecimenID]], integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
+
* [[Specimens|SpecimenID]], integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
 
* [[SpecimenCategories|SpmnCategoryID]], integer, 4 bytes, identifier for the category
 
* [[SpecimenCategories|SpmnCategoryID]], integer, 4 bytes, identifier for the category
 
* Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1")
 
* Count, integer, 2 bytes, (-1 means "many", -2 means "more than 1")

Latest revision as of 10:25, 7 September 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