[Gusdev-gusdev] Phenotype tables

[Arnaud K. <ax...@sa...>]

  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