MatchingIDs
From Species File Help
(Difference between revisions)
| (3 intermediate revisions by one user not shown) | |||
| 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. | ||
*TableID, integer, 4 bytes = tblTables.TableID | *TableID, integer, 4 bytes = tblTables.TableID | ||
*IDrelationshipID, integer, 1 byte, = tblIDrelationships.IDrelationship | *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 | *ID1, integer, 4 bytes | ||
| − | *ID2, integer, 4 bytes | + | *ID1FileID, integer, 4bytes |
| − | *Status, integer, 1 byte, | + | *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 | *LastUpdate, smalldatetime, date and time row last updated | ||
*ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | ||
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.
- If IDrelationshipID = 1
- 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
