Difference between revisions of "Data model"
From mx Help Wiki
m |
|||
Line 13: | Line 13: | ||
* GBIF IPT table for easy 1:1 integration (Spring 2011) | * GBIF IPT table for easy 1:1 integration (Spring 2011) | ||
− | === In progress additions === | + | === In progress additions/modifications === |
* The phenotype cluster is presently (January 2011) in development and will likely evolve slightly in the following weeks | * 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 === | === In Rails === |
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