Database Properties
Database Type: PostgreSQL - 10.3 (Debian 10.3-1.pgdg90+1)
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| activity_type | 2 | 0 | 2 | 4 | Table | This is mostly "none", "routine" or "campaign" but with a few extras |
| api_access_log | 0 | 1 | 6 | 0 | Table | |
| app_user | 4 | 0 | 5 | 0 | Table | |
| burden_estimate | 0 | 4 | 7 | 0 | Table | |
| burden_estimate_country_expectation | 0 | 2 | 2 | 0 | Table | |
| burden_estimate_expectation | 3 | 0 | 9 | 0 | Table | This table, in combination with burden_estimate_country_expectation and burden_estimate_outcome_expectation, describes in detail the burden estimates we expect to be uploaded for a particular responsibility. If you imagine plotting expected year and age combinations on x and y axes, then the year_* and age_* columns provide a rectangular area. Within those bounds, the cohort columns optionally give us the ability to describe a triangular area. If a cohort_min_inclusive is defined then only people born in that year and afterwards are included. So if this is set to 2000 then the only ages expected in 2000 are 0. Whereas by 2010, ages 0 - 10 are expected. Similarly, if cohort_max_inclusive is defined then only people born in that year or before are included. |
| burden_estimate_outcome_expectation | 0 | 2 | 2 | 0 | Table | |
| burden_estimate_set | 6 | 6 | 14 | 0 | Table | |
| burden_estimate_set_problem | 0 | 1 | 3 | 0 | Table | |
| burden_estimate_set_status | 1 | 0 | 2 | 4 | Table | |
| burden_estimate_set_type | 1 | 0 | 3 | 4 | Table | |
| burden_outcome | 3 | 0 | 4 | 37 | Table | |
| cofinance_status | 1 | 0 | 2 | 0 | Table | |
| country | 13 | 0 | 3 | 251 | Table | |
| country_cofinance | 0 | 3 | 5 | 0 | Table | |
| country_disease_endemic | 0 | 3 | 4 | 0 | Table | |
| country_fragility | 0 | 2 | 5 | 0 | Table | |
| country_metadata | 0 | 5 | 18 | 0 | Table | |
| country_vaccine_metadata | 0 | 3 | 7 | 0 | Table | |
| country_worldbank_status | 0 | 3 | 5 | 0 | Table | |
| coverage | 0 | 3 | 11 | 0 | Table | |
| coverage_set | 4 | 4 | 6 | 0 | Table | |
| demographic_dataset | 2 | 2 | 4 | 0 | Table | |
| demographic_source | 3 | 0 | 3 | 0 | Table | |
| demographic_statistic | 0 | 6 | 11 | 0 | Table | |
| demographic_statistic_type | 3 | 2 | 9 | 0 | Table | |
| demographic_statistic_type_variant | 0 | 2 | 2 | 0 | Table | |
| demographic_value_unit | 1 | 0 | 2 | 13 | Table | |
| demographic_variant | 3 | 0 | 3 | 0 | Table | |
| disability_weight | 0 | 2 | 7 | 0 | Table | |
| disease | 8 | 0 | 2 | 0 | Table | |
| francophone_status | 1 | 0 | 1 | 0 | Table | Status within the Organisation internationale de la Francophonie |
| gavi_eligibility | 0 | 3 | 5 | 0 | Table | |
| gavi_eligibility_status | 1 | 0 | 2 | 5 | Table | |
| gavi_focal_model | 0 | 3 | 4 | 0 | Table | |
| gavi_region | 1 | 0 | 2 | 0 | Table | include four types of gavi region interested by gavi donors |
| gavi_support_level | 1 | 0 | 2 | 8 | Table | Enum table. Possible values: none (No vaccination), without (Vaccination without GAVI support), with (Vaccination with GAVI support) |
| gender | 2 | 0 | 3 | 3 | Table | |
| impact_estimate | 0 | 2 | 5 | 0 | Table | |
| impact_estimate_ingredient | 2 | 3 | 5 | 0 | Table | |
| impact_estimate_recipe | 2 | 8 | 13 | 0 | Table | |
| impact_estimate_set | 3 | 5 | 7 | 0 | Table | |
| impact_estimate_set_ingredient | 0 | 3 | 4 | 0 | Table | |
| impact_outcome | 1 | 0 | 2 | 4 | Table | |
| legal_agreement | 1 | 0 | 2 | 1 | Table | |
| model | 2 | 3 | 7 | 0 | Table | With the self-referencing "current" field; we consider a model to be the current one if current is null. See comment about recursion in modelling_group |
| model_run | 2 | 1 | 3 | 0 | Table | |
| model_run_parameter | 1 | 1 | 3 | 0 | Table | |
| model_run_parameter_set | 3 | 3 | 4 | 0 | Table | |
| model_run_parameter_value | 0 | 2 | 4 | 0 | Table |