IDrelationships
From Species File Help
(Difference between revisions)
(created page) |
Revision as of 11:34, 30 August 2012
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