MatchingIDs

From Species File Help
Revision as of 11:52, 18 October 2013 by Dceades (Talk | contribs)

Jump to: navigation, search

tblMatchingIDs, related ID values in the same table.

  • The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.
  • TableID, integer, 4 bytes = tblTables.TableID
  • IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
  • ID1, integer, 4 bytes
  • ID1FileID, integer, 4bytes
  • ID2, integer, 4 bytes
  • ID2FileID, integer, 4bytes
  • Status, integer, 1 byte, explained in tblIDrelationships.
  • 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
Retrieved from "http://help.speciesfile.org/index.php?title=MatchingIDs&oldid=1643"
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox