Once data from OpenSRP has been received in Reveal's raw tables, it is then transformed and stored in so called "transaction" tables. The transformation here is mainly some normalization to produce tables from the JSON received in "raw tables.
These are the resulting tables:
- actions: stores plan actions
- clients: stores clients
- events: stores events
- goals: stores plan goals
- goal_target: stores goal targets
- jurisdictions: stores jurisdictions
- plan_jurisdiction: maps plans to jurisdictions
- plans: stores plans
- locations: stores locations
- tasks: stores tasks
If these migrations are run, this is the resulting entity relationship diagram:
