CoLNameRefLinks
From Species File Help
(Difference between revisions)
(Remove column NameType; now in tmpCoL_IDs) |
(added column ID) |
||
| Line 1: | Line 1: | ||
'''tmpCoLNameRefLinks''', linking table for references and names | '''tmpCoLNameRefLinks''', linking table for references and names | ||
| + | *ID, integer, = tmpCoL_IDs | ||
*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. | ||
Latest revision as of 17:09, 22 August 2013
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
