RelatedTaxa

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, 2 bytes, UserID of the signon that made the change