IDrelationships
From Species File Help
(Difference between revisions)
(created page) |
|||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | '''tblIDrelationships''', types of relationships between IDs | + | '''tblIDrelationships''', types of relationships between IDs as used in tblMatchingIDs |
| − | + | * IDrelationshipID, integer, 1 byte | |
| − | + | ** 1. ID2 copied from ID1 in spin off. tblMatchingIDs.Status is defined as: | |
| − | + | *** 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 | |
| − | + | ** 2. ID1 merged to create ID2. tblMatchingIDs.Status is defined as: | |
| − | + | *** 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 | |
| − | + | ** 3. ID2 reserved for future merge of ID1. Status is not used. | |
| − | + | ** 4. ID1 is the same as ID2 in a different species file. For future development. | |
| − | + | * Description, text, 50 characters maximum. | |
| − | + | * 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 | |
[[Category:IDrelationshipTables]] | [[Category:IDrelationshipTables]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 15:45, 8 November 2013
tblIDrelationships, types of relationships between IDs as used in tblMatchingIDs
- IDrelationshipID, integer, 1 byte
- 1. ID2 copied from ID1 in spin off. tblMatchingIDs.Status is defined as:
- 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
- 2. ID1 merged to create ID2. tblMatchingIDs.Status is defined as:
- 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
- 3. ID2 reserved for future merge of ID1. Status is not used.
- 4. ID1 is the same as ID2 in a different species file. For future development.
- 1. ID2 copied from ID1 in spin off. tblMatchingIDs.Status is defined as:
- Description, text, 50 characters maximum.
- 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
