IDrelationships

From Species File Help
Revision as of 22:37, 24 February 2013 by Dceades (Talk | contribs)

Jump to: navigation, search

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 = 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. 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.
  • 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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox