Home › Forums › Developer Forums › Technical Collaboration Forum

Feature Request: Make Taxon-->CommonName One to Many

Wed, 03/10/2010 - 14:32 — Herrick Brown

Is it possible to create a linked table for vernaculars with fields such as VernacularID=unique key, TaxonID=FK, VernacularName, Language? And could this be displayed in a Form View as either a drop down or grid? I suspect this has been discussed, but I recently discovered that our Taxon Tree which was originally imported in Specify5 from direct downloads of ITIS data has some unusual common names. Apparently during that initial import process, only the first (alphabetically) vernacular name was retained...all others associated with a single ITIS taxonomic record were apparently discarded because the basic schema in Specify allows for only a One to One relationship by embedding CommonName within the Taxon record.

Respectfully submitted,
H

‹ error on dataset upload Feature request: Allow editing of Workbench data set mappings ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Mon, 03/22/2010 - 12:58 — rods

Taxon->CommonNameTX

There is already a table in the schema for a one-top-many from Taxon to CommonNameTX

The Schema is available for review, here is the link for the Taxon table:
http://specify6.specifysoftware.org/schema/Taxon.html