MatchingIDs

From Species File Help
(Difference between revisions)
Jump to: navigation, search
 
Line 1: Line 1:
 
'''tblMatchingIDs''', related ID values in the same table.
 
'''tblMatchingIDs''', related ID values in the same table.
 +
Part of this description applies only to cases where TableID = 21 (tblTaxa).
  
 
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.
 
*The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.
Line 5: Line 6:
 
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
 
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
 
** 1 = ID2 copied from ID1 in spin off.
 
** 1 = ID2 copied from ID1 in spin off.
** 2 = ID1 merged to create ID2.
+
** 2 = ID1 merged to create ID2. Applies only when a new row was created in the spun off species file.
 
** 3 = ID2 reserved for future merge of ID1.
 
** 3 = ID2 reserved for future merge of ID1.
 
*ID1, integer, 4 bytes
 
*ID1, integer, 4 bytes

Latest revision as of 12:34, 13 January 2014

tblMatchingIDs, related ID values in the same table. Part of this description applies only to cases where TableID = 21 (tblTaxa).

  • The primary key is composed of TableID, IDrelationshipID, ID1 and ID2.
  • TableID, integer, 4 bytes = tblTables.TableID
  • IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship
    • 1 = ID2 copied from ID1 in spin off.
    • 2 = ID1 merged to create ID2. Applies only when a new row was created in the spun off species file.
    • 3 = ID2 reserved for future merge of ID1.
  • ID1, integer, 4 bytes
  • ID1FileID, integer, 4bytes
  • ID2, integer, 4 bytes
  • ID2FileID, integer, 4bytes
  • Status, integer, 1 byte
    • If IDrelationshipID = 1
      • 0 = ID2 created by spin off
      • 1 = Merge started, if ID1 was deleted, it has been re-created
      • 2 = Values for LikeNameID and OriginalGenusID are resolved
      • 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed
    • If IDrelationshipID = 2
      • 0 = ID2 has been reserved, but not created
      • 1 = ID2 has been created
      • 2 = Values for LikeNameID and OriginalGenusID are resolved
      • 5 = Values for RefID and CurrentConceptRefID resolved; merge process completed
    • If IDrelationshipID = 3
      • Status is not used.
  • 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