CoLSynonyms

Revision as of 13:08, 8 September 2012

tmpCoLSynonyms

• TaxonNameID, integer, 4 bytes, primary key for this table and for tblTaxa in the species file
• AcceptedNameID, integer, 4 bytes, = tmpCoLAcceptedSpecies.TaxonNameID or tmpCoLAcceptedInfraSpecific.TaxonNameID
• 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"