Difference between revisions of "Chado Natural Diversity Module/natdiv schema changes call"

From GMOD
Jump to: navigation, search
(Created page with "call to resolve the latest proposed changes to natdiv module, date TBC ==participants== ==agenda== ==proposed changes== ===prop table in genotype module=== *change: addition o…")
 
(proposed changes)
Line 4: Line 4:
 
==agenda==
 
==agenda==
  
==proposed changes==  
+
==proposed changes==
 
===prop table in genotype module===
 
===prop table in genotype module===
 
*change: addition of (vanilla) prop table to genotype module [cvterm_id, value, rank]
 
*change: addition of (vanilla) prop table to genotype module [cvterm_id, value, rank]
 
**proposer: Seth Redmond / Vectorbase
 
**proposer: Seth Redmond / Vectorbase
 
**reason: enables us to store ontology terms for current genotypes, e.g. presence/absence of specific inversions - impossible under current schema
 
**reason: enables us to store ontology terms for current genotypes, e.g. presence/absence of specific inversions - impossible under current schema
 +
===Hackathon changes===
 +
* phenotype
 +
* phenotypeprop
 +
===Yuri's proposals===
 +
* Add environmentprop.  This is useful when creating phenstatements.
 +
* Add phenstatementprop.  This is useful when creating phenstatements.
 +
* Add nd_experiment_protocolprop.  I use this to store protocol values specific to an nd_experiment.
 +
* Add nd_experiment_phenotypeprop.  I use this to store phenotype observations specific to an nd_experiment.
 +
* Add cvalue_id to NatDiv property tables and  related property tables like projectprop.  This allows for postcomposition of cvterms like units to the property type_id.

Revision as of 20:23, 13 May 2011

call to resolve the latest proposed changes to natdiv module, date TBC

participants

agenda

proposed changes

prop table in genotype module

  • change: addition of (vanilla) prop table to genotype module [cvterm_id, value, rank]
    • proposer: Seth Redmond / Vectorbase
    • reason: enables us to store ontology terms for current genotypes, e.g. presence/absence of specific inversions - impossible under current schema

Hackathon changes

  • phenotype
  • phenotypeprop

Yuri's proposals

  • Add environmentprop. This is useful when creating phenstatements.
  • Add phenstatementprop. This is useful when creating phenstatements.
  • Add nd_experiment_protocolprop. I use this to store protocol values specific to an nd_experiment.
  • Add nd_experiment_phenotypeprop. I use this to store phenotype observations specific to an nd_experiment.
  • Add cvalue_id to NatDiv property tables and related property tables like projectprop. This allows for postcomposition of cvterms like units to the property type_id.