IDrelationships
From Species File Help
tblIDrelationships, types of relationships between IDs
- IDrelationshipID, integer, 1 byte
- Description, text, 50 characters maximum. The following square bullet points list values for IDrelationshipID and Description. ID1, ID2 and Status refer to columns contained in other tables shown on this page.
- 1. ID2 copied from ID1 in spin off. Status is defined as:
- 0 = TaxonNameID2 created by spin off
- 1 = Merge started, if TaxonNameID1 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. Status is defined as:
- 0 = TaxonNameID2 has been reserved, but not created
- 1 = TaxonNameID2 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. Status is defined as:
- 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