RelatedTaxa
From Species File Help
tblRelatedTaxa is a linking table used 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, 2 bytes, UserID of the signon that made the change