CoLSynonyms
From Species File Help
(Difference between revisions)
(cat) |
m |
||
Line 2: | Line 2: | ||
*TaxonNameID, integer, 4 bytes, primary key for this table and for tblTaxa in the species file | *TaxonNameID, integer, 4 bytes, primary key for this table and for tblTaxa in the species file | ||
− | * | + | *AcceptedTaxonID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID or tmpCoLAcceptedInfraSpecific.AccepteTaxonID |
*Genus, text (nvarchar), 30 character maximum, name of the genus | *Genus, text (nvarchar), 30 character maximum, name of the genus | ||
*Subgenus, text (nvarchar), 30 character maximum, name of the subgenus | *Subgenus, text (nvarchar), 30 character maximum, name of the subgenus |
Revision as of 14:18, 1 October 2012
tmpCoLSynonyms
- TaxonNameID, integer, 4 bytes, primary key for this table and for tblTaxa in the species file
- AcceptedTaxonID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID or tmpCoLAcceptedInfraSpecific.AccepteTaxonID
- Genus, text (nvarchar), 30 character maximum, name of the genus
- Subgenus, text (nvarchar), 30 character maximum, name of the subgenus
- Species, text (nvarchar), 30 character maximum, name of the species
- AuthorString, text (nvarchar), 500 character maximum, author and year for the taxon.
- InfraSpecies, text, 30 character maximum, infraspecific name
- InfraSpMarker, text, 10 character maximum
- InfraSpecificAuthorString, text (nvarchar), 500 character maximum, author and year for the name
- GSDNameStatus, text, 1000 character maximum, nomenclatural information about the taxon
- Sp2000NameStatus, text, 30 character maximum, restricted vocabulary specified by CoL
- GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345"