SpecimenCounts

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(added content)
Line 1: Line 1:
 
'''tblSpecimenCounts''' contains counts for various specimen categories.
 
'''tblSpecimenCounts''' contains counts for various specimen categories.
  
*SpecimenID, integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
+
* [[Specimen|SpecimenID]], integer, 4 bytes, = tblSpecimens.SpecimenID, identifier for specimen
*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")
*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]]

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