CoLNameRefLinks

From Species File Help
Revision as of 10:39, 31 August 2012 by Maehr (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox