RelatedTaxa

From Species File Help
Jump to: navigation, search

tblRelatedTaxa, linking table to record nomenclatural relationships between taxonomic names.

  • OlderNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, TaxonNameID for the older name in the relationship
  • YoungerNameID, integer, 4 bytes, = tblTaxa.TaxonNameID, TaxonNameID for the younger name in the relationship
  • Relationship, integer, 1 byte
    • 1 = junior homonym/nomen novum
    • 2 = nomen oblitum/nomen protectum
    • 3 = incorrect original spelling/justified emendation
    • 4 = correct spelling/subsequent misspelling
    • 5 = correct name/unjustified emendation
    • 6 = correct name/unnecessary replacement
    • 7 = correct use of name/misapplied name
    • 8 = lapsus calami/corrected lapsus
    • 9 = nomen nudum/nomen nudum made available
  • 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