NOTE: We are working on migrating this site away from MediaWiki, so editing pages will be disabled for now.
Difference between revisions of "Chado Natural Diversity Module/natdiv schema changes call"
From GMOD
(→Yuri's proposals) |
RobertBuels (Talk | contribs) (cleaned up formatting a bit) |
||
| Line 1: | Line 1: | ||
| − | call to resolve the latest proposed changes to natdiv module | + | Conference call to resolve the latest proposed changes to natdiv module. |
| − | + | ||
| − | == | + | == Date == |
| − | ==proposed changes== | + | Thursday, May 26, 6pm BST / 1pm EST / 10am PST |
| − | === | + | |
| + | == Participants == | ||
| + | |||
| + | == Agenda == | ||
| + | |||
| + | 1. Triage proposed changes into the following categories: | ||
| + | * implement before paper publishing | ||
| + | * implement after paper publishing | ||
| + | * do not implement | ||
| + | |||
| + | == Proposed changes == | ||
| + | |||
| + | === 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=== | + | |
| + | === Hackathon changes === | ||
* phenotype | * phenotype | ||
* phenotypeprop (Can somebody add the reason for adding this table?) | * phenotypeprop (Can somebody add the reason for adding this table?) | ||
| − | ===Yuri's proposals=== | + | === Yuri's proposals === |
| + | |||
* Add environmentprop. This is useful when creating phenstatements. | * Add environmentprop. This is useful when creating phenstatements. | ||
* Add phenstatementprop. This is useful when creating phenstatements. | * Add phenstatementprop. This is useful when creating phenstatements. | ||
Revision as of 15:49, 24 May 2011
Conference call to resolve the latest proposed changes to natdiv module.
Contents
Date
Thursday, May 26, 6pm BST / 1pm EST / 10am PST
Participants
Agenda
1. Triage proposed changes into the following categories:
- implement before paper publishing
- implement after paper publishing
- do not implement
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 (Can somebody add the reason for adding this table?)
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.
- Chado has some way to post-compose cvterms which Maccallr 11:56, 17 May 2011 (UTC) doesn't understand.
