Phenotype Module

[spficklin]

This issue imported from the Chado v1.4 requested changes google doc:

http://gmod.827538.n3.nabble.com/proposal-for-changes-to-the-phenotype-module-tc4044535.html#a4044612

• Deprecate fields of the phenotype table: observable_id, attr_id, cvalue_id, assay_id
• New tables:
  • phenotype_cvtermrelationship
• Naama Menda says (3/11/2015): Inclined towards option #1 http://gmod.org/wiki/Chado_Post-Composed_Phenotypes#Option_1:_Group_Module_is_an_intrinsic_part_of_the_phenotype_cvterm_table
• Need a way to decouple phenotype description from its value, and to allow post-composing of phenotypes , e.g. EQ statements.
• Valentin Guignon says (3/11/2015): about names, I suggest phenotype_cvtermrelationship → phenotype_cvterm_composition and rank → composition_order (or keep rank and add a column composition_order and adjust constraints according to that)