IDrelationships

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.
   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