SpecimenCategories

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(created page)
Line 1: Line 1:
tblSpecimenCategories contains categories of specimens (male, female, egg, etc.) added in version 4.0.
+
tblSpecimenCategories contains categories of specimens (male, female, egg, etc.).
  
    SpmnCategoryID, integer, 2 bytes, primary key, identifier for the category
+
*SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category
    Name, text, 30 characters maximum
+
*FileID, integer, 4 bytes, = tblFiles.FileID
    SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists
+
*SingularName, text, 30 characters maximum
    LastUpdate, smalldatetime, date and time of last update
+
*PluralName, text, 30 characters maximum
    ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
+
*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
  
 
[[Category:SpecimenTables]]
 
[[Category:SpecimenTables]]

Revision as of 10:36, 29 August 2012

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