RelatedTaxa
From Species File Help
(Difference between revisions)
(created page) |
Revision as of 10:54, 27 August 2012
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
