SpecimenCategories

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m
m
 
Line 1: Line 1:
 
'''tblSpecimenCategories''' contains categories of specimens (male, female, egg, etc.).
 
'''tblSpecimenCategories''' contains categories of specimens (male, female, egg, etc.).
  
*SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category
+
* SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category
*FileID, integer, 4 bytes, = tblFiles.FileID
+
* [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID
*SingularName, text, 30 characters maximum
+
* SingularName, text, 30 characters maximum
*PluralName, text, 30 characters maximum
+
* PluralName, text, 30 characters maximum
*SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists
+
* SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists
*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]]

Latest revision as of 08:35, 7 September 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