Difference between revisions of "Data model"
From mx Help Wiki
m |
|||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| + | === Schema === | ||
| − | The [http://mx.phenomix.org/schema/ schema is available here]. See also a [[Data dictionary]] and below | + | The [http://mx.phenomix.org/schema/ schema is available here]. See also a [[Data dictionary]] and below. |
| − | --- | + | === Planned deprecations === |
| + | |||
| + | * Type information is now tied through type specimens, not through fields in the TaxonName table. | ||
| + | * Statements table is legacy and not used. | ||
| + | * Xyl tables are install-specific and can be ignored. | ||
| + | |||
| + | === Planned additions === | ||
| + | |||
| + | * GBIF IPT table for easy 1:1 integration (Spring 2011) | ||
| + | |||
| + | === In progress additions/modifications === | ||
| + | |||
| + | * The phenotype cluster is presently (January 2011) in development and will likely evolve slightly in the following weeks | ||
| + | * The sequence module is being revised slightly (January 2011)- long term plans for the Sequence table is to adopt a GMOD/Chado-esque approach | ||
| + | |||
| + | === In Rails === | ||
You can also see the full schema used by Rails by dumping it via rake task like so: | You can also see the full schema used by Rails by dumping it via rake task like so: | ||
| Line 8: | Line 24: | ||
rake db:schema:dump | rake db:schema:dump | ||
| − | + | === Other === | |
The figure below highlights some of the connections to the OTU model. not all foreign keys are shown. | The figure below highlights some of the connections to the OTU model. not all foreign keys are shown. | ||
[[File:Schema schematic.png]] | [[File:Schema schematic.png]] | ||
Latest revision as of 10:24, 25 January 2011
Contents |
[edit] Schema
The schema is available here. See also a Data dictionary and below.
[edit] Planned deprecations
- Type information is now tied through type specimens, not through fields in the TaxonName table.
- Statements table is legacy and not used.
- Xyl tables are install-specific and can be ignored.
[edit] Planned additions
- GBIF IPT table for easy 1:1 integration (Spring 2011)
[edit] In progress additions/modifications
- The phenotype cluster is presently (January 2011) in development and will likely evolve slightly in the following weeks
- The sequence module is being revised slightly (January 2011)- long term plans for the Sequence table is to adopt a GMOD/Chado-esque approach
[edit] In Rails
You can also see the full schema used by Rails by dumping it via rake task like so:
rake db:schema:dump
[edit] Other
The figure below highlights some of the connections to the OTU model. not all foreign keys are shown.
Error creating thumbnail: Unable to save thumbnail to destination
