SpecimenCategories

From Species File Help
Jump to: navigation, search

tblSpecimenCategories contains categories of specimens (male, female, egg, etc.).

  • SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category
  • FileID, integer, 4 bytes, = tblFiles.FileID
  • SingularName, text, 30 characters maximum
  • PluralName, text, 30 characters maximum
  • SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists
  • 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