RelatedTaxa
From Species File Help
(Difference between revisions)
(formatting) |
|||
| Line 1: | Line 1: | ||
| − | '''tblRelatedTaxa''' | + | '''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]] | ||
Revision as of 16:10, 29 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, 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
