**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 ^
| DTM_DisplacementData | [[DTM_DisplacementData |Crop yield from the FEWS Source]] |
| FAO_ChildStuntedWastingOverweight | [[FAO_ChildStuntedWastingOverweight |Percent of children under 5 who are stunted, wasting, and overweight]] |
| FAO_CostAffordabilityHealthyDiet | [[FAO_CostAffordabilityHealthyDiet |Number of people who can't afford a healthy diet]] |
| FAO_CostOfHealthyDiet | [[FAO_CostOfHealthyDiet |Cost of a healthy diet (kcal/cap/day)]] |
| FAO_FoodBalanceSupply | [[FAO_FoodBalanceSupply |Food supply measured in average dietary energy requirement]] |
| FAO_FoodSecurityData | [[FAO_FoodSecurityData |Per capita food supply variability (kcal/cap/day)]] |
| FAO_FoodSupplyLosses | [[FAO_FoodSupplyLosses |Food Losses in 1000 tonnes]] |
| FAO_TempChange | [[FAO_TempChange |Temperature change on land]] |
| FEWS_CropYieldData | [[FEWS_CropYieldData |Crop yield from the FEWS Source]] |
| IDX_BaselinePopulation | [[IDX_BaselinePopulation |Population and demographics]] |
| IDX_ConflictEvents | [[IDX_ConflictEvents |Data on protests and political violence]] |
| IDX_FoodPrices | [[IDX_FoodPrices |Prices of different food groups]] |
| IDX_FoodSecurity | [[IDX_FoodSecurity |IPC Acute Food Insecurity classification data]] |
| IDX_Funding | [[IDX_Funding |Funding to countries vs their humanitarian response needs]] |
| IDX_Humanitarian | [[IDX_Humanitarian |Number of people who need assistance in an area]] |
| IDX_NationalRisk | [[IDX_NationalRisk |INFORM Risk Index data]] |
| IDX_OperationalPresence | [[IDX_OperationalPresence |Geographical data of humanitarian activity]] |
| IDX_PovertyRate | [[IDX_PovertyRate |Poverty rate data]] |
| IDX_Rainfall | [[IDX_Rainfall |Periodic rainfall data]] |
| IDX_Refugees | [[IDX_Refugees |Data on number and demographics of forcibly displaced people]] |
| IDX_returnees | [[IDX_returnees |Displaced people based on country of origin and asylum]] |
| WB_PopulationGrowth | [[WB_PopulationGrowth |Percentage increase in the population]] |
| WB_ConsumerPriceInflation | [[WB_ConsumerPriceInflation |Inflation measured by percentage change in consumer price]] |
| WB_IndustrialDesignApplications | [[WB_IndustrialDesignApplications |Industrial design applications registered by residents]] |