|
From: Linda S. <Lin...@cg...> - 2005-02-23 15:28:32
|
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= |