Data model

From mx Help Wiki
Revision as of 10:22, 25 January 2011 by Matt (Talk | contribs)

Jump to: navigation, search

Contents

Schema

The 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

  • The phenotype cluster is presently (January 2011) in development and will likely evolve slightly in the following weeks

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.

Error creating thumbnail: Unable to save thumbnail to destination
Retrieved from "http://mx.phenomix.org/index.php?title=Data_model&oldid=3818"
Personal tools