CoLSynonyms

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"