Database Layouts for the ECU dashboard
The Grafana program is connected to a MySQL database which gets updated daily from a CRON script. This script queries the API endpoints to check for new data in the timeframe, and if it exists then update the database.
Grafana can be updated to include new datasets as database tables are created.
| Database name | Schema details |
|---|---|
| FEWS_CropYieldData | Crop yield from the FEWS Source |
| HDX_FoodMarketInfo | Food market info from the HDX source |
| HDX_PovertyRates | Information regarding poverty rates from HDX |
| HDX_RainfallData | periodic rainfall data |