CoLNameRefLinks
From Species File Help
(Difference between revisions)
(cat) |
(Remove column NameType; now in tmpCoL_IDs) |
||
Line 2: | Line 2: | ||
*TaxonNameID, integer, 4 bytes, = tmpCoLAcceptedSpecies.TaxonNameID or tmpCoLAcceptedInfraSpecific.TaxonNameID or tmpCoLSynonyms.TaxonNameID | *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. | *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 | *RefID, integer, 4 bytes, = tmpColReferences.RefID |
Revision as of 15:04, 1 October 2012
tmpCoLNameRefLinks, linking table for references and names
- 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