Difference between revisions of "Chado Natural Diversity Module/natdiv schema changes call"
From GMOD
(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
Contents
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.