Taxon_Name
Description:
Name Null? Type
------------------------------- -------- ----
TAXON_NAME_ID NOT NULL NUMBER
TAXON_NAME_TEXT VARCHAR2(35)
ORIGINAL_AUTHOR VARCHAR2(25)
- Primary Key:
- Taxon_Name_ID
The Taxon_Name_ID is a unique number generated by the Oracle server. Thus
homonyms, even those by the same author, may be easily differentiated.
I have decided that the text of the name of species and subspecies will
include the genus, species, and subspecies names just to simplify the process
of name retrieval (i.e., I don't have to go and look up the genus and concatenate
the two names). I've also chosen to use the actual text of the original author's name(s)
along with the parentheses where required.
The Taxon_Name_ID allows entry into the Determination
table (and thence to individual specimens) and into the taxonomic hierarchy
through the Taxon_Name_Use table. This is the only
table in which names are stored. Thus corrections and updates only have to
be made in one place.
Last updated: 20 November, 1997 by nfj.