[BioSQL-l] synonyms for ontology terms
Aaron J Mackey
ajm6q at virginia.edu
Sat Mar 15 13:24:44 EST 2003
Works for me; the only alternative arrangement I could possibly imagine
being useful would be like taxon/taxon_name arrangement, wherein all
"names" of the thing exist in the second table, with labels for
canonical/synonymous/etc (the advantage being the one-step, one-parameter,
one-placeholder select by name).
Of course, there is one other option; let synonyms exist as separate
ontology terms with relationships of "is-synonymous-to".
-Aaron
On Fri, 14 Mar 2003, Hilmar Lapp wrote:
> We need one more table for a full representation of ontology terms to
> record their synonyms. The table can be quite minimalist:
>
> CREATE TABLE term_synonym (
> synonym VARCHAR(255) NOT NULL,
> term_id INT(10) UNSIGNED NOT NULL,
> --
> FOREIGN KEY (term_id) REFERENCES term (term_id),
> UNIQUE (term_id,synonym);
> );
>
> Has anyone any objections to this or better ideas how to capture
> synonyms of terms?
>
> -hilmar
>
--
Aaron J Mackey
Pearson Laboratory
University of Virginia
(434) 924-2821
amackey at virginia.edu
More information about the BioSQL-l
mailing list