Differences

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

--- databaseschema [2025/09/03 07:57] – created alex.nevin
+++ databaseschema [2025/10/11 04:46] (current) – Updated table to include all tables 14.201.148.205
@@ Line 1: / Line 1: @@
-## Database Layouts for the ECU dashboard ##
+**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]] |