CoLNameRefLinks

From Species File Help
Jump to: navigation, search

tmpCoLNameRefLinks, linking table for references and names

  • ID, integer, = tmpCoL_IDs
  • TaxonNameID, integer, 4 bytes, = tmpCoLAcceptedSpecies.TaxonNameID or tmpCoLAcceptedInfraSpecific.TaxonNameID or tmpCoLSynonyms.TaxonNameID
  • 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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox