MatchingSpmnCategoryIDs
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
Line 1: | Line 1: | ||
'''tblMatchingSpmnCategoryIDs''', related values for tblSpecimenCategories.SpmnCategoryID | '''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 | |
[[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