[BioSQL-l] term synonym

[Hilmar Lapp]

There is one small issue with the naming used in the Mysql and 
PostgreSQL schemas, namely this definition of the term_synonym table:

-- ontology terms have synonyms, here is how to store them
CREATE TABLE term_synonym (
        synonym            VARCHAR(255) BINARY NOT NULL,
        term_id            INT(10) UNSIGNED NOT NULL,
        PRIMARY KEY (term_id,synonym)
) TYPE=INNODB;

Synonym is a reserved word in many RDBMSs, so the column synonym may 
eventually be renamed to name, which is its name already in the HSQL 
and Oracle versions.

Is the Mysql or PostgreSQL term_synonym table used with the current 
naming anywhere outside of bioperl? Does anybody have an opinion on 
whether this should be changed now or in a later release only of found 
necessary?

I'm leaning towards leaving it as it is for now but am open if people 
feel differently.

	-hilmar

-- 
-------------------------------------------------------------
Hilmar Lapp                            email: lapp at gnf.org
GNF, San Diego, Ca. 92121              phone: +1-858-812-1757
-------------------------------------------------------------