As noted in tripal/tripal#2280 the cvtermsynonym table has a unique constraint that only includes cvterm_id and synonym.
"cvtermsynonym_c1" UNIQUE CONSTRAINT, btree (cvterm_id, synonym)
Some ontologies like EDAM may define more than one synonym type for the same synonym name, e.g.
synonym: "Quality" BROAD []
synonym: "Quality" RELATED []
So this ontology cannot be fully represented in chado currently.
Should the unique constraint be updated to include type_id? It would be backwards compatible.
As noted in tripal/tripal#2280 the
cvtermsynonymtable has a unique constraint that only includescvterm_idandsynonym."cvtermsynonym_c1" UNIQUE CONSTRAINT, btree (cvterm_id, synonym)Some ontologies like EDAM may define more than one synonym type for the same synonym name, e.g.
So this ontology cannot be fully represented in chado currently.
Should the unique constraint be updated to include
type_id? It would be backwards compatible.