[BioSQL-l] synonyms for ontology terms

[Aaron J Mackey]

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