Difference between revisions of "Data model"
From mx Help Wiki
m (Created page with 'File:Example.jpg') |
m |
||
(8 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
− | [[File: | + | === Schema === |
+ | |||
+ | 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: | ||
+ | |||
+ | rake db:schema:dump | ||
+ | |||
+ | === Other === | ||
+ | |||
+ | The figure below highlights some of the connections to the OTU model. not all foreign keys are shown. | ||
+ | |||
+ | [[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