Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
agasti:mayon:schema [2010/09/02 15:39] darlenem created |
agasti:mayon:schema [2011/05/24 10:04] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
====== Mayon DB Schema ====== | ====== Mayon DB Schema ====== | ||
+ | Attached below is the first public draft of the Agasti Mayon database schema being developed by the CUNY SPS Agasti Team. The design patterns of this schema are largely directed by the conventions of the Doctrine Object Relational Mapper (ORM) engine. | ||
- | Below is the most recent | + | ==== General Guidelines ==== |
+ | This schema | ||
+ | * reduces data assumptions | ||
+ | * creates more options for modular plugins | ||
+ | * establishes strong data standards | ||
+ | * better anticipates longitudinal function | ||
+ | * improves performance | ||
+ | * reduces database size | ||
- | **Please | + | ==== Limitations ==== |
- | {{: | + | There are also a number of challenges yet to be overcome. While the Doctrine ORM provides a number of useful features the following issues are impairing efforts to simplify the design: |
+ | | ||
+ | | ||
+ | * Doctrine does not support a many-to-many relationship between more than two tables (eg, no three or four-way M-M) | ||
+ | |||
+ | ==== Modules ==== | ||
+ | * [[agasti: | ||
+ | |||
+ | ==== Schema Diagram ==== | ||
+ | Please | ||
+ | |||
+ | {{: | ||
+ | |||
+ | //This diagram was developed using the non-free tool, ORM Designer. The schema itself is distributed as yml.// |