MatchingSpmnCategoryIDs

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(formatting, cat)
Line 1: Line 1:
 
'''tblMatchingSpmnCategoryIDs''', related values for tblSpecimenCategories.SpmnCategoryID
 
'''tblMatchingSpmnCategoryIDs''', related values for tblSpecimenCategories.SpmnCategoryID
  
    SpmnCategoryID1, integer, 4 bytes
+
*SpmnCategoryID1, integer, 4 bytes
    SpmnCategoryID2, integer, 4 bytes
+
*SpmnCategoryID2, integer, 4 bytes
    IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
+
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
    Status, integer, 1 byte, explained in tblIDrelationships.
+
*Status, integer, 1 byte, explained in tblIDrelationships.
    LastUpdate, smalldatetime, date and time row last updateddd
+
*LastUpdate, smalldatetime, date and time row last updateddd
    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:IDrelationshipTables]]
 
[[Category:IDrelationshipTables]]
 +
[[Category:Tables]]

Revision as of 15:52, 8 September 2012

tblMatchingSpmnCategoryIDs, related values for tblSpecimenCategories.SpmnCategoryID

  • SpmnCategoryID1, integer, 4 bytes
  • SpmnCategoryID2, integer, 4 bytes
  • IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
  • Status, integer, 1 byte, explained in tblIDrelationships.
  • LastUpdate, smalldatetime, date and time row last updateddd
  • 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