CoLNameRefLinks
From Species File Help
(Difference between revisions)
(created page) |
Revision as of 10:39, 31 August 2012
tmpCoLNameRefLinks, linking table for references and names
TaxonNameID, integer, 4 bytes, = tmpCoLAcceptedSpecies.TaxonNameID or tmpCoLAcceptedInfraSpecific.TaxonNameID or tmpCoLSynonyms.TaxonNameID NameType, text, 12 bytes maximum, = Species, Infraspecies or Synonym to identify which table ReferenceType, text, 10 bytes maximum, = NomRef, ComNameRef, TaxAccRef, TaxSynRef or null string. Although this matches a column in the Exchange Format, the Catalogue of Life does not use the information at this time. In addition, the Standard Dataset does not include TaxSynRef, which is clearly needed for a reference that states a name is a synonym of something else. This column will be left blank until something changes at the Catalogue of Life. RefID, integer, 4 bytes, = tmpColReferences.RefID