RelatedTaxa

From Species File Help
Revision as of 16:10, 29 August 2012 by Maehr (Talk | contribs)

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