Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
model_run_parameter Table model_run_parameter_set int4 10 null
burden_estimate_expectation Table version text 2147483647 null
region_subnational Table country int4 10 null
model Table description text 2147483647 null
impact_estimate_set Table recipe_touchstone text 2147483647 null
demographic_statistic Table year int4 10 null
disease Table id text 2147483647 null
burden_estimate_set Table comment text 2147483647 √ null
demographic_subnational_statistic Table demographic_dataset int4 10 null
model_run Table run_id text 2147483647 null
demographic_source Table code text 2147483647 null
vaccine_routine_age Table vaccine text 2147483647 null
responsibility Table scenario int4 10 null
app_user Table last_logged_in timestamp 29 √ null
cofinance_status Table name text 2147483647 null
dettl_import_log Table git_branch text 2147483647 √ null
coverage_set Table touchstone text 2147483647 null
burden_estimate_set Table complete bool 1 false
country_fragility Table country text 2147483647 null
country_metadata Table gavi_pef_tier int4 10 √ null

Gavi Partners engagement framework; Tier 1, 2 or 3 (stored as integer). NULL values indicate "Not PEF"
country_cofinance Table cofinance_status text 2147483647 null
burden_estimate_expectation Table year_max_inclusive int2 5 null
impact_estimate_recipe Table support_type text 2147483647 null
legal_agreement Table name text 2147483647 null
demographic_statistic_type Table id serial 10 √ nextval('demographic_statistic_type_id_seq'::regclass)
modelling_group Table comment text 2147483647 √ null
dettl_import_log Table git_email text 2147483647 √ null
country_metadata Table id serial 10 √ nextval('country_metadata_id_seq'::regclass)
v_coverage_info View touchstone text 2147483647 √ null
burden_estimate Table burden_outcome int2 5 null
demographic_statistic Table demographic_source int4 10 null
demographic_dataset Table description text 2147483647 null
impact_estimate_ingredient Table impact_estimate_recipe int4 10 null
v_responsibility_info View responsibility_id int4 10 √ null
app_user Table email text 2147483647 √ null
role Table scope_prefix text 2147483647 √ null
coverage Table country text 2147483647 √ null
coverage Table gavi_support bool 1 √ null
model Table citation text 2147483647 √ null
gavi_eligibility_status Table name text 2147483647 √ null
country_metadata Table touchstone text 2147483647 null
schema_version Table type varchar 20 null
country_vaccine_metadata Table year_support_first int4 10 √ null
api_access_log Table who text 2147483647 √ null
impact_estimate_recipe Table version int4 10 null
responsibility Table current_stochastic_burden_estimate_set int4 10 √ null
coverage_set Table coverage_set_upload_metadata int4 10 √ null
gender Table name varchar 6 null
dettl_import_log Table git_hash bpchar 40 √ null
touchstone_demographic_source Table touchstone text 2147483647 null
onetime_token Table token text 2147483647 null
responsibility_set_status Table id text 2147483647 null
responsibility Table responsibility_set int4 10 null
country_disease_endemic Table country text 2147483647 null
disease Table name varchar 2147483647 null
touchstone_status Table id text 2147483647 null
demographic_statistic_type Table year_step_size int4 10 null
role_permission Table permission text 2147483647 null
api_access_log Table what text 2147483647 null
v_coverage_info View gavi_support_level text 2147483647 √ null
impact_estimate_recipe Table current_impact_estimate_set int4 10 √ null
country_metadata Table gavi73 bool 1 null
country_worldbank_status Table touchstone text 2147483647 null
dettl_import_log Table duration float4 8 √ null
disability_weight Table disability_weight_max numeric 131089 √ null
model_run_parameter_set Table model_version int4 10 null
upload_info Table id serial 10 √ nextval('upload_info_id_seq'::regclass)
impact_estimate_set Table coverage_touchstone text 2147483647 √ null
touchstone_name Table comment text 2147483647 null
coverage_set_upload_metadata Table uploaded_on timestamp 29 CURRENT_TIMESTAMP
role Table id serial 10 √ nextval('role_id_seq'::regclass)
demographic_value_unit Table name text 2147483647 null

A free text description
country_cofinance Table touchstone text 2147483647 null
responsibility Table expectations int4 10 √ null
role_permission Table role int4 10 null
model_version Table fingerprint text 2147483647 √ null
country_metadata Table wuenic_coverage bool 1 null
country_metadata Table gavi_region text 2147483647 null
coverage_set_upload_metadata Table uploaded_by text 2147483647 null
vaccine Table id text 2147483647 'NULL'::text
impact_estimate_set_ingredient Table burden_estimate_set int4 10 null
burden_estimate Table age int2 5 √ null
model Table disease text 2147483647 √ null
vaccine Table name text 2147483647 null
coverage Table age_range_verbatim text 2147483647 √ null
burden_estimate_country_expectation Table burden_estimate_expectation int4 10 null
coverage_set_upload_metadata Table id serial 10 √ nextval('coverage_set_upload_metadata_id_seq'::regclass)
burden_estimate_set_problem Table problem text 2147483647 null
responsibility_set_status Table name text 2147483647 null
touchstone_name Table description text 2147483647 null
impact_estimate_recipe Table focal_ingredient int4 10 √ null
v_responsibility_info View disease text 2147483647 √ null
impact_estimate_recipe Table id serial 10 √ nextval('impact_estimate_recipe_id_seq'::regclass)
demographic_statistic Table gender int4 10 null
schema_version Table script varchar 1000 null
touchstone_demographic_source Table id serial 10 √ nextval('touchstone_demographic_source_id_seq'::regclass)
burden_estimate_expectation Table age_max_inclusive int2 5 null
modelling_group Table pi text 2147483647 null
scenario_coverage_set Table id serial 10 √ nextval('scenario_coverage_set_id_seq'::regclass)
coverage_set Table name text 2147483647 null
country_cofinance Table year int4 10 null
country_metadata Table dove96 bool 1 null
burden_estimate_outcome_expectation Table outcome text 2147483647 null
burden_outcome Table proportion bool 1 √ false
v_responsibility_info View status text 2147483647 √ null
impact_estimate_set Table impact_estimate_recipe int4 10 null
demographic_statistic_type_variant Table demographic_variant int4 10 null
demographic_statistic Table country text 2147483647 null
touchstone_demographic_source Table demographic_source int4 10 null
country_vaccine_metadata Table id serial 10 √ nextval('country_vaccine_metadata_id_seq'::regclass)
country_metadata Table francophone text 2147483647 null

28 Gavi-supported French-speaking countries of interest to Gavi donors + 1 associated member + 4 observer counrties
schema_version Table checksum int4 10 √ null
user_group_role Table user_group text 2147483647 null
demographic_statistic_type Table age_interpretation text 2147483647 null
responsibility_set Table touchstone text 2147483647 null
demographic_statistic Table value numeric 131089 null
impact_estimate Table impact_estimate_set int4 10 null
dettl_import_log Table mode text 2147483647 √ null
disability_weight Table disease text 2147483647 null
impact_estimate_set Table focal_burden_estimate_set int4 10 null
demographic_source Table name varchar 2147483647 null
country_worldbank_status Table id serial 10 √ nextval('country_worldbank_status_id_seq'::regclass)
activity_type Table id text 2147483647 'NULL'::text
user_legal_agreement Table legal_agreement text 2147483647 √ null
burden_estimate_expectation Table age_min_inclusive int2 5 null
responsibility_set Table id serial 10 √ nextval('responsibility_set_id_seq'::regclass)
country_metadata Table who_region text 2147483647 null
burden_estimate_set Table uploaded_on timestamp 29 date_trunc('milliseconds'::text, now())
worldbank_status Table name text 2147483647 null
country_vaccine_metadata Table touchstone text 2147483647 null
demographic_statistic Table id serial 10 √ nextval('demographic_statistic_id_seq'::regclass)
impact_estimate_set Table id serial 10 √ nextval('impact_estimate_set_id_seq'::regclass)
scenario Table id serial 10 √ nextval('scenario_id_seq'::regclass)
model_run Table model_run_parameter_set int4 10 null
country_cofinance Table id serial 10 √ nextval('country_cofinance_id_seq'::regclass)
coverage Table coverage numeric 131089 √ null
touchstone_name Table id text 2147483647 null
api_access_log Table id serial 10 √ nextval('api_access_log_id_seq'::regclass)
disability_weight Table disability_weight numeric 131089 null
country_metadata Table gavi68 bool 1 null
impact_estimate_ingredient Table burden_outcome int2 5 null
dettl_import_log Table name text 2147483647 null
responsibility_comment Table id serial 10 √ nextval('responsibility_comment_id_seq'::regclass)
burden_estimate_set Table original_filename text 2147483647 √ null
disability_weight Table disability_weight_min numeric 131089 √ null
country_metadata Table continent text 2147483647 null
coverage Table age_from numeric 131089 null
demographic_statistic Table age_from int4 10 null
scenario_coverage_set Table scenario int4 10 null
impact_estimate_recipe Table name text 2147483647 null
impact_estimate_ingredient Table name text 2147483647 null
country_fragility Table is_fragile bool 1 null
touchstone Table comment text 2147483647 null
impact_estimate_recipe Table activity_type text 2147483647 null
impact_estimate_recipe Table disease text 2147483647 null
impact_estimate_set_ingredient Table impact_estimate_set int4 10 null
v_coverage_info View coverage_set_id int4 10 √ null
v_responsibility_info View touchstone text 2147483647 √ null
burden_estimate Table year int2 5 null
model Table gender_specific bool 1 √ false
coverage_set Table vaccine text 2147483647 null
impact_estimate_set Table focal_coverage_set int4 10 null
gavi_eligibility Table status int4 10 √ null
touchstone_country Table disease text 2147483647 null
burden_estimate_set Table model_version int4 10 null
country_metadata Table pine_5 bool 1 null
impact_estimate Table country text 2147483647 null
touchstone_country Table country text 2147483647 null
burden_estimate_expectation Table cohort_min_inclusive int2 5 √ null
demographic_subnational_statistic Table id serial 10 √ nextval('demographic_subnational_statistic_id_seq'::regclass)
burden_estimate_expectation Table description text 2147483647 null
impact_estimate_ingredient Table id serial 10 √ nextval('impact_estimate_ingredient_id_seq'::regclass)
burden_estimate_outcome_expectation Table burden_estimate_expectation int4 10 null
touchstone_years Table year_last int4 10 null
demographic_value_unit Table id serial 10 √ nextval('demographic_value_unit_id_seq'::regclass)
coverage Table year int4 10 √ null
country_metadata Table gavi77 bool 1 null
gavi_focal_model Table model text 2147483647 null
touchstone_years Table year_first int4 10 null
scenario_description Table disease text 2147483647 null
burden_estimate_set Table interpolated bool 1 null
country_metadata Table vxdel_segment text 2147483647 null

An internal grouping as used by BMFG to stratify countries
model_version_country Table country text 2147483647 null
region_subnational Table admin_level int4 10 null
responsibility Table id serial 10 √ nextval('responsibility_id_seq'::regclass)
user_group_membership Table user_group text 2147483647 null
v_responsibility_info View scenario_description text 2147483647 √ null
burden_estimate_set_type Table code text 2147483647 null
demographic_dataset Table demographic_statistic_type int4 10 null
demographic_subnational_statistic Table value numeric 131089 null
burden_estimate_expectation Table year_min_inclusive int2 5 null
burden_estimate_expectation Table id serial 10 √ nextval('burden_estimate_expectation_id_seq'::regclass)
impact_outcome Table name text 2147483647 null
coverage_set Table activity_type text 2147483647 null
v_coverage_info View disease text 2147483647 √ null
burden_outcome Table code text 2147483647 null
burden_estimate_set Table validation text 2147483647 √ null
burden_estimate_set_type Table is_valid_option bool 1 √ null

New burden_estimate_set rows should only be created with set types that have is_valid_option to true. Those with false are for legacy data
demographic_statistic_type Table reference_date date 13 null
user_group Table description text 2147483647 √ null
gender Table id serial 10 √ nextval('gender_id_seq'::regclass)
demographic_source Table id serial 10 √ nextval('demographic_source_id_seq'::regclass)
touchstone_years Table id serial 10 √ nextval('touchstone_years_id_seq'::regclass)
scenario_type Table name varchar 255 null
burden_estimate_set Table run_info text 2147483647 null
burden_estimate_set Table uploaded_by text 2147483647 null
impact_estimate_recipe Table impact_outcome text 2147483647 null
gavi_focal_model Table touchstone text 2147483647 null
model_run_parameter_set Table upload_info int4 10 null
touchstone_country Table touchstone text 2147483647 null
coverage_set_upload_metadata Table filename text 2147483647 √ null
impact_estimate_recipe Table comment text 2147483647 √ null
upload_info Table uploaded_by text 2147483647 null
touchstone Table id text 2147483647 null
user_legal_agreement Table date timestamp 29 √ CURRENT_TIMESTAMP
gavi_eligibility Table country text 2147483647 √ null
gavi_eligibility Table touchstone text 2147483647 √ null
country_fragility Table year int4 10 null
gavi_region Table id text 2147483647 null
responsibility_comment Table added_on timestamp 29 null
country_metadata Table dove94 bool 1 null
coverage Table age_to numeric 131089 null
model_version Table model text 2147483647 null
touchstone Table touchstone_name text 2147483647 null
burden_estimate Table country int2 5 null
scenario Table touchstone text 2147483647 'NULL'::text
model_version Table code text 2147483647 √ null
responsibility_comment Table comment text 2147483647 null
country_vaccine_metadata Table year_vaccine_intro int4 10 √ null
model_version_country Table model_version int4 10 null
coverage_set Table id serial 10 √ nextval('coverage_set_id_seq'::regclass)
responsibility_comment Table added_by text 2147483647 null
gavi_focal_model Table disease text 2147483647 null
touchstone_status Table name text 2147483647 null
scenario_description Table id text 2147483647 null
demographic_dataset Table id serial 10 √ nextval('demographic_dataset_id_seq'::regclass)
impact_estimate Table id serial 10 √ nextval('impact_estimate_id_seq'::regclass)
model Table current_version int4 10 √ null
v_coverage_info View vaccine text 2147483647 √ null
country_vaccine_metadata Table year_support_last int4 10 √ null
demographic_subnational_statistic Table age_from int4 10 null
burden_estimate_set_status Table code text 2147483647 null

Valid values: {empty, partial, complete, invalid}
demographic_statistic Table age_to int4 10 √ null
disability_weight Table id serial 10 √ nextval('disability_weight_id_seq'::regclass)
dettl_import_log Table language text 2147483647 √ null
demographic_statistic Table demographic_variant int4 10 √ null
api_access_log Table timestamp timestamp 29 null
user_group_membership Table username text 2147483647 null
impact_estimate_recipe Table script text 2147483647 null
model Table gender int4 10 √ null
impact_estimate_set_ingredient Table impact_estimate_ingredient int4 10 √ null
schema_version Table success bool 1 null
country_worldbank_status Table worldbank_status text 2147483647 null
api_access_log Table result int4 10 √ null

The HTTP status code returned by the API
app_user Table password_hash text 2147483647 √ null
modelling_group Table institution text 2147483647 null
cofinance_status Table id text 2147483647 null
model_run_parameter_value Table model_run_parameter int4 10 null
burden_estimate_set Table model_run_parameter_set int4 10 √ null
responsibility Table is_open bool 1 √ true
demographic_statistic_type Table name varchar 2147483647 null
burden_estimate Table model_run int4 10 √ null
vaccine_routine_age Table id serial 10 √ nextval('vaccine_routine_age_id_seq'::regclass)
dettl_import_log Table git_user text 2147483647 √ null
impact_estimate_set Table computed_on timestamp 29 CURRENT_TIMESTAMP
demographic_subnational_statistic Table age_to int4 10 null
v_responsibility_info View current_burden_estimate_set int4 10 √ null
impact_outcome Table id text 2147483647 null
demographic_statistic Table demographic_statistic_type int4 10 null
api_access_log Table ip_address text 2147483647 √ null
model_run_parameter Table key text 2147483647 null
burden_outcome Table name text 2147483647 null
demographic_statistic_type Table default_variant int4 10 null
modelling_group Table id text 2147483647 null
scenario Table focal_coverage_set int4 10 √ null
country_metadata Table region text 2147483647 null
gavi_focal_model Table id serial 10 √ nextval('gavi_focal_model_id_seq'::regclass)
gavi_eligibility Table id serial 10 √ nextval('gavi_eligibility_id_seq'::regclass)
schema_version Table installed_on timestamp 29 now()
onetime_token Table id serial 10 √ nextval('onetime_token_id_seq'::regclass)
touchstone Table description text 2147483647 null
user_group_role Table scope_id text 2147483647 null
demographic_statistic_type Table gender_is_applicable bool 1 null
worldbank_status Table id text 2147483647 null
gavi_eligibility_status Table id int4 10 null
model_run_parameter_set Table responsibility_set int4 10 null
model_run_parameter_value Table value text 2147483647 null
touchstone_demographic_dataset Table id serial 10 √ nextval('touchstone_demographic_dataset_id_seq'::regclass)
country Table name text 2147483647 null
schema_version Table execution_time int4 10 null
model_run_parameter_value Table model_run int4 10 null
burden_estimate_set Table set_type_details text 2147483647 √ null
app_user Table name text 2147483647 √ null
country_vaccine_metadata Table country text 2147483647 null
user_legal_agreement Table username text 2147483647 √ null
schema_version Table installed_rank int4 10 null
app_user Table username text 2147483647 null
francophone_status Table id text 2147483647 null
burden_estimate_set Table set_type text 2147483647 'central-unknown'::text
burden_estimate_set_status Table description text 2147483647 null
dettl_import_log Table comment text 2147483647 √ null
coverage_set Table gavi_support_level text 2147483647 null
scenario_coverage_set Table order int4 10 null
dettl_import_log Table end_time timestamptz 35 √ null
region_subnational Table parent_id int4 10 √ null
country_worldbank_status Table year int4 10 null
model Table is_current bool 1 false
burden_estimate Table value float4 8 √ null
support_type Table id text 2147483647 null
country Table id text 2147483647 null
impact_estimate_recipe Table vaccine text 2147483647 null
gavi_eligibility Table year int4 10 √ null
support_type Table name text 2147483647 null
country_disease_endemic Table touchstone text 2147483647 null
country_disease_endemic Table id serial 10 √ nextval('country_disease_endemic_id_seq'::regclass)
country_cofinance Table country text 2147483647 null
responsibility_set Table modelling_group text 2147483647 null
disability_weight Table sequela text 2147483647 null
model_version Table note text 2147483647 √ null
scenario_description Table scenario_type text 2147483647 null
gavi_support_level Table name varchar 255 'NULL'::character varying
schema_version Table version varchar 50 √ null
v_coverage_info View activity_type text 2147483647 √ null
coverage_set_upload_metadata Table description text 2147483647 null
demographic_variant Table id serial 10 √ nextval('demographic_variant_id_seq'::regclass)
touchstone_country Table id serial 10 √ nextval('touchstone_country_id_seq'::regclass)
country_fragility Table touchstone text 2147483647 null
country Table nid int2 5 √ null
impact_estimate_set_ingredient Table id serial 10 √ nextval('impact_estimate_set_ingredient_id_seq'::regclass)
model_run_parameter_set Table id serial 10 √ nextval('model_run_parameter_set_id_seq'::regclass)
schema_version Table description varchar 200 null
touchstone_demographic_dataset Table demographic_dataset int4 10 null
model_version Table is_dynamic bool 1 √ false
demographic_variant Table name varchar 2147483647 'NULL'::character varying
touchstone Table version int4 10 null
country_metadata Table gavi72 bool 1 null
permission Table name text 2147483647 null
gavi_region Table name text 2147483647 null
demographic_statistic_type Table demographic_value_unit int4 10 null
coverage Table coverage_set int4 10 null
coverage Table subnational bool 1 √ null
legal_agreement Table description text 2147483647 null
demographic_statistic Table demographic_dataset int4 10 √ null
impact_estimate Table year int4 10 null
responsibility Table current_burden_estimate_set int4 10 √ null
burden_estimate Table burden_estimate_set int4 10 null
burden_estimate_set Table responsibility int4 10 null
scenario_type Table id text 2147483647 null
region_subnational Table name text 2147483647 null
v_coverage_info View scenario_description text 2147483647 √ null
model_version Table version text 2147483647 null
role Table name text 2147483647 null
demographic_dataset Table demographic_source int4 10 null
gavi_support_level Table id text 2147483647 null
burden_estimate_set_problem Table id serial 10 √ nextval('burden_estimate_set_problem_id_seq'::regclass)
role Table description text 2147483647 null
impact_estimate Table value numeric 131089 √ null
dettl_import_log Table start_time timestamptz 35 √ null
vxdel_segment Table id text 2147483647 null
model_run_parameter_value Table id serial 10 √ nextval('model_run_parameter_value_id_seq'::regclass)
model_run_parameter Table id serial 10 √ nextval('model_run_parameter_id_seq'::regclass)
scenario_coverage_set Table coverage_set int4 10 null
country_disease_endemic Table disease text 2147483647 null
impact_estimate_recipe Table responsibility_set int4 10 null
touchstone_years Table disease text 2147483647 null
demographic_variant Table code text 2147483647 null
user_group_role Table role int4 10 null
gender Table code text 2147483647 null
model_run Table internal_id serial 10 √ nextval('model_run_internal_id_seq'::regclass)
scenario Table scenario_description text 2147483647 null
coverage Table target numeric 131089 √ null

This field is valid only for campaign coverage
demographic_statistic_type_variant Table demographic_statistic_type int4 10 null
responsibility_comment Table responsibility int4 10 null
activity_type Table name varchar 255 'NULL'::character varying
model Table id text 2147483647 null
country_worldbank_status Table country text 2147483647 null
touchstone_demographic_dataset Table touchstone text 2147483647 null
demographic_statistic_type Table code text 2147483647 null
model_version Table id serial 10 √ nextval('model_version_id_seq'::regclass)
scenario_description Table description text 2147483647 null
coverage Table id serial 10 √ nextval('coverage_id_seq'::regclass)
country_vaccine_metadata Table vaccine text 2147483647 null
burden_estimate_country_expectation Table country text 2147483647 null
country_metadata Table country text 2147483647 null
user_group Table id text 2147483647 null
disability_weight Table touchstone text 2147483647 null
responsibility_set Table status text 2147483647 null
burden_outcome Table id int2 5 √ nextval('burden_outcome_id_seq'::regclass)
touchstone Table status text 2147483647 null
demographic_subnational_statistic Table region int4 10 null
model Table modelling_group text 2147483647 'NULL'::text
vaccine_routine_age Table age int4 10 √ null
burden_estimate_set_type Table description text 2147483647 null
impact_estimate_ingredient Table responsibility int4 10 null
schema_version Table installed_by varchar 100 null
country_fragility Table id serial 10 √ nextval('country_fragility_id_seq'::regclass)
demographic_subnational_statistic Table year int4 10 null
burden_estimate_set Table id serial 10 √ nextval('burden_estimate_set_id_seq'::regclass)
burden_estimate_expectation Table cohort_max_inclusive int2 5 √ null
coverage Table gender int4 10 √ null
region_subnational Table id serial 10 √ nextval('region_subnational_id_seq'::regclass)
demographic_subnational_statistic Table gender int4 10 null
user_group Table name text 2147483647 null
modelling_group Table description text 2147483647 null
modelling_group Table replaced_by text 2147483647 √ null
touchstone_years Table touchstone text 2147483647 null
burden_estimate_set Table status text 2147483647 'complete'::text
burden_estimate_set_problem Table burden_estimate_set int4 10 null
upload_info Table uploaded_on timestamp 29 √ date_trunc('milliseconds'::text, now())