RelatedTaxa
From Species File Help
(Difference between revisions)
(formatting, cat) |
|||
| Line 1: | Line 1: | ||
'''tblRelatedTaxa''', linking table to record nomenclatural relationships between taxonomic names. | '''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 | |
[[Category:TaxaTables]] | [[Category:TaxaTables]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 10:11, 9 September 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, 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
