[Gmod-schema] genetic module

[Linda S. <Lin...@cg...>]

Hello,

I have a question about the phenstatement table of the genetic module.

Since the phenstatement is a "single atomic phenotypic observation", I=20=

do not understand why the unique constraint is on "gcontext_id,=20
dbxref_id, observable_id"!

First, what does dbxref  refer to?

The main problem, is the unique constraint on the observable_id.

For example, I need to model a paramecium mutant that has the following=20=

phenotypes (hence two phenstatements for one gcontext) :

Observable =3D cell, Attribute =3D size, Value =3D SmallSize
Observable =3D cell, Attribute =3D shape, Value =3D Abnormal

This apparently would violate the unique constraint on the=20
observable_id.

If attribute_id were also included in the unique constraint, then it=20
would be OK.


Regards,
Linda Sperling


Linda Sperling
Centre de G=E9n=E9tique Mol=E9culaire
CNRS
Avenue de la Terrasse
91198 Gif-sur-Yvette CEDEX
FRANCE

spe...@cg...
+33 (0)1 69 82 32 09 	(telephone)
+33 (0)1 69 82 31 50	(fax)
http://paramecium.cgm.cnrs-gif.fr

SAUVONS LA RECHERCHE
http://recherche-en-danger.apinc.org=