[BioSQL-l] synonyms for ontology terms

[Hilmar Lapp]

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
-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------