CoLSynonyms
From Species File Help
(Difference between revisions)
(created page) |
|||
(5 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
'''tmpCoLSynonyms''' | '''tmpCoLSynonyms''' | ||
− | + | *ID, integer, 4 bytes, primary key, = tmpCoL_IDs.ID | |
− | + | *AcceptedTaxonID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID or tmpCoLAcceptedInfraSpecific.AcceptedTaxonID | |
− | + | *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 as "Unambiguous synonym", "Ambiguous synonym" or "Misapplied name". | |
− | + | *GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345" | |
[[Category:CoLTables]] | [[Category:CoLTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 12:03, 10 November 2012
tmpCoLSynonyms
- ID, integer, 4 bytes, primary key, = tmpCoL_IDs.ID
- AcceptedTaxonID, integer, 4 bytes, = tmpCoLAcceptedSpecies.AcceptedTaxonID or tmpCoLAcceptedInfraSpecific.AcceptedTaxonID
- 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 as "Unambiguous synonym", "Ambiguous synonym" or "Misapplied name".
- GSDNameGUI, text, 100 character maximum, for example "urn:lsid:blattodea.speciesfile.org:taxonName:12345"