Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
agasti:mayon:schema [2011/05/21 17:28]
cheuschober
agasti:mayon:schema [2011/05/24 10:04] (current)
Line 2: Line 2:
 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. 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.
  
-=== General Guidelines ===+==== General Guidelines ====
 This schema was designed to largely follow the guidelines of the fourth normal form. This choice: This schema was designed to largely follow the guidelines of the fourth normal form. This choice:
   * reduces data assumptions   * reduces data assumptions
Line 11: Line 11:
   * reduces database size    * reduces database size 
  
-=== Limitations ===+==== 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: 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 has difficulty establishing a 1-1 relationship where the primary key of each table is also member of the foreign key relationship   * Doctrine has difficulty establishing a 1-1 relationship where the primary key of each table is also member of the foreign key relationship
Line 17: Line 17:
   * Doctrine does not support a many-to-many relationship between more than two tables (eg, no three or four-way M-M)   * Doctrine does not support a many-to-many relationship between more than two tables (eg, no three or four-way M-M)
  
 +==== Modules ====
 +  * [[agasti:mayon:agSkill|Skills and Certification]]
  
- +==== Schema Diagram ====
-=== Schema Diagram ===+
 Please Note: The schema is still undergoing heavy development and migration support is not currently provided. Click to view full details and zoom: Please Note: The schema is still undergoing heavy development and migration support is not currently provided. Click to view full details and zoom:
  
-{{:agasti:mayon:mayon-schema-20110323.png?400}}+{{:agasti:mayon:mayon-schema-20110523.png?400}}
  
 //This diagram was developed using the non-free tool, ORM Designer. The schema itself is distributed as yml.// //This diagram was developed using the non-free tool, ORM Designer. The schema itself is distributed as yml.//

QR Code
QR Code agasti:mayon:schema (generated for current page)