Re: [Gusdev-gusdev] Phenotype tables

[Chris S. <sto...@pc...>]

Hi Arnaud,
These look fine to me and represent what we've discussed. Thanks for 
putting this together!
Cheers,
Chris

On Monday, November 11, 2002, at 06:53  AM, Arnaud Kerhornou wrote:

>  Hi everyone
>
> I've attached SQL statements and doc for draft tables and views for 
> holding genetic data.
>
> You'll find statements for:
>
> Allele tables:
>
> * Allele table,
> * AlleleInstance table,
> * AlleleFeature view,
>
> * A Complementation table which stores complementation data. It works 
> as a reference table to another allele. It can be an internal or an 
> external reference. There are three types of complementation 
> references : "complements", "complemented_by", "fails_to_complement".
>
> Controlled vocabulary tables:
> * PhenotypeClass - controlled vocabulary to classify the allele 
> effects - recessif/dominant - lethal,
> * Mutagen - controlled vocabulary of chemical products used to 
> generate mutants,
>
> and
> * AllelePhenotypeClass,
> * AlleleMutagen,
> * AllelePhenotype,
> * AlleleComplementation,
>
> * RNAi table to store RNAi constructs data,
> * RNAiPhenotype table.
>
> Please let me know if you have any questions or comments.
> cheers
> Arnaud
> <phenotype.tar.gz>