MatchingSourceIDs

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(created page)
 
(formatting, cat)
Line 1: Line 1:
 
'''tblMatchingSourceIDs''', related values for tblSources.SourceID
 
'''tblMatchingSourceIDs''', related values for tblSources.SourceID
  
    SourceID1, integer, 4 bytes
+
*SourceID1, integer, 4 bytes
    SourceID2, integer, 4 bytes
+
*SourceID2, 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:50, 8 September 2012

tblMatchingSourceIDs, related values for tblSources.SourceID

  • SourceID1, integer, 4 bytes
  • SourceID2, 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