Difference between revisions of "Data model"

From mx Help Wiki
Jump to: navigation, search
Line 1: Line 1:
 +
=== Schema ===
  
The [http://mx.phenomix.org/schema/ schema is available here].  See also a [[Data dictionary]] and below.  Upcoming major additions include a table with 1:1 mapping to GBIFs IPT.  
+
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 ===
 +
 
 +
* 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:
 
You can also see the full schema used by Rails by dumping it via rake task like so:
Line 8: Line 23:
 
   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]]

Revision as of 10:22, 25 January 2011

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
Personal tools