api_country

285 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_country_id_seq'::regclass)
api_appeal.country_id api_appeal_country_id_914a0751_fk_api_country_idR
api_appealhistory.country_id api_appealhistory_country_id_a6e61f17_fk_api_country_idR
api_country.sovereign_state_id api_country_sovereign_state_id_720e1e48_fk_api_country_idR
api_countrycapacitystrengthening.country_id api_countrycapacitys_country_id_b8ee87ba_fk_api_countR
api_countrycontact.country_id api_countrycontact_country_id_140aebd7_fk_api_country_idR
api_countrydirectory.country_id api_countrydirectory_country_id_72951541_fk_api_country_idR
api_countrygeoms.country_id api_countrygeoms_country_id_5168d01e_fk_api_country_idR
api_countryicrcpresence.country_id api_countryicrcpresence_country_id_894a1a06_fk_api_country_idR
api_countrykeydocument.country_id api_countrykeydocument_country_id_def8e8ea_fk_api_country_idR
api_countrykeyfigure.country_id api_countrykeyfigure_country_id_ac7743e9_fk_api_country_idR
api_countrylink.country_id api_countrylink_country_id_be58427b_fk_api_country_idR
api_countryoffieldreporttoreview.country_id api_countryoffieldre_country_id_1a628672_fk_api_countR
api_countryorganizationalcapacity.country_id api_countryorganizat_country_id_7ff9ee01_fk_api_countR
api_countrysnippet.country_id api_countrysnippet_country_id_17235975_fk_api_country_idR
api_countrysupportingpartner.country_id api_countrysupportin_country_id_df5647f9_fk_api_countR
api_district.country_id api_district_country_id_b4999656_fk_api_country_idR
api_event_countries.country_id api_event_countries_country_id_97e53123_fk_api_country_idR
api_event_countries_for_preview.country_id api_event_countries__country_id_03fca10d_fk_api_countR
api_fieldreport_countries.country_id api_fieldreport_countries_country_id_fbaec807_fk_api_country_idR
api_gdacsevent_countries.country_id api_gdacsevent_countries_country_id_f07c652e_fk_api_country_idR
api_geccode.country_id api_geccode_country_id_6fa6f288_fk_api_country_idR
api_nsdinitiatives.country_id api_nsdinitiatives_country_id_72ebcf72_fk_api_country_idR
api_profile.country_id api_profile_country_id_d438e32c_fk_api_country_idR
api_usercountry.country_id api_usercountry_country_id_2bc77ab6_fk_api_country_idR
country_plan_countryplan.country_id country_plan_countryplan_country_id_cefd962c_fk_api_country_idR
country_plan_membershipcoordination.national_society_id country_plan_members_national_society_id_506fe6a5_fk_api_countR
databank_countryoverview.country_id databank_countryoverview_country_id_12f9fccf_fk_api_country_idR
deployments_emergencyproject.country_id deployments_emergenc_country_id_15bda26c_fk_api_countR
deployments_emergencyproject.reporting_ns_id deployments_emergenc_reporting_ns_id_252d470d_fk_api_countR
deployments_eru.deployed_to_id deployments_eru_deployed_to_id_0149f892_fk_api_country_idR
deployments_eruowner.national_society_country_id deployments_eruowner_national_society_cou_f5f671bf_fk_api_countR
deployments_fact.country_id deployments_fact_country_id_4f80d5ad_fk_api_country_idR
deployments_heop.country_id deployments_heop_country_id_30ddffc2_fk_api_country_idR
deployments_partnersocietydeployment.country_deployed_to_id deployments_partners_country_deployed_to__989ecfd3_fk_api_countR
deployments_partnersocietydeployment.parent_society_id deployments_partners_parent_society_id_e5654e9d_fk_api_countR
deployments_personnel.country_from_id deployments_personne_country_from_id_f0930561_fk_api_countR
deployments_personnel.country_to_id deployments_personnel_country_to_id_728793e5_fk_api_country_idR
deployments_personneldeployment.country_deployed_to_id deployments_personne_country_deployed_to__4695aac7_fk_api_countR
deployments_project.project_country_id deployments_project_project_country_id_6f298b36_fk_api_countR
deployments_project.reporting_ns_id deployments_project_reporting_ns_id_fbb8a843_fk_api_country_idR
deployments_rdrt.country_id deployments_rdrt_country_id_4c48f351_fk_api_country_idR
dref_dref.country_id dref_dref_country_id_39892d1a_fk_api_country_idR
dref_dref.national_society_id dref_dref_national_society_id_4cd1766d_fk_api_country_idR
dref_dreffinalreport.country_id dref_dreffinalreport_country_id_bb3cf1f7_fk_api_country_idR
dref_dreffinalreport.national_society_id dref_dreffinalreport_national_society_id_13ff5dc8_fk_api_countR
dref_drefoperationalupdate.country_id dref_drefoperational_country_id_eaafc58e_fk_api_countR
dref_drefoperationalupdate.national_society_id dref_drefoperational_national_society_id_46c3e863_fk_api_countR
eap_eap.country_id eap_eap_country_id_4b6a3187_fk_api_country_idR
flash_update_flashcountrydistrict.country_id flash_update_flashco_country_id_b6d3911c_fk_api_countR
local_units_delegationoffice.country_id local_units_delegati_country_id_f6f9e51e_fk_api_countR
local_units_externallymanagedlocalunit.country_id local_units_external_country_id_ee34f26d_fk_api_countR
local_units_localunit.country_id local_units_localunit_country_id_46e84ce1_fk_api_country_idR
local_units_localunitbulkupload.country_id local_units_localuni_country_id_6fc7e7fc_fk_api_countR
notifications_subscription.country_id notifications_subscr_country_id_27a8c38f_fk_api_countR
notifications_surgealert.country_id notifications_surgealert_country_id_75cbcde5_fk_api_country_idR
per_customperworkplancomponent.supported_by_id per_customperworkpla_supported_by_id_697b0cf3_fk_api_countR
per_nicedocument.country_id per_nicedocument_country_id_d9f3317e_fk_api_country_idR
per_nsphase.country_id per_nsphase_country_id_73bdb58a_fk_api_country_idR
per_overview.country_id per_overview_country_id_23a4f3d1_fk_api_country_idR
per_perdocumentupload.country_id per_perdocumentupload_country_id_202c225b_fk_api_country_idR
per_perworkplancomponent.supported_by_id per_perworkplancompo_supported_by_id_604b7b64_fk_api_countR
per_workplan.country_id per_workplan_country_id_00f2b749_fk_api_country_idR
name varchar 100 null
iso varchar 2 √ null
api_appealdocument.iso api_appealdocument_iso_568e8089_fk_api_country_isoR
society_name text 2147483647 null
society_url varchar 200 null
region_id int4 10 √ null
api_region.id api_country_region_id_f142f638_fk_api_region_idR
inform_score numeric 3,2 √ null
key_priorities text 2147483647 √ null
overview text 2147483647 √ null
varchar 100 √ null
record_type int4 10 null
iso3 varchar 3 √ null
wb_population int4 10 √ null
wb_year varchar 4 √ null
url_ifrc varchar 200 null
bbox geometry 2147483647 √ null
centroid geometry 2147483647 √ null
independent bool 1 √ null
name_ar varchar 100 √ null
name_en varchar 100 √ null
name_es varchar 100 √ null
name_fr varchar 100 √ null
overview_ar text 2147483647 √ null
overview_en text 2147483647 √ null
overview_es text 2147483647 √ null
overview_fr text 2147483647 √ null
society_name_ar text 2147483647 √ null
society_name_en text 2147483647 √ null
society_name_es text 2147483647 √ null
society_name_fr text 2147483647 √ null
is_deprecated bool 1 null
additional_tab_name varchar 100 null
wash_kit10 int4 10 √ null
wash_kit2 int4 10 √ null
wash_kit5 int4 10 √ null
wash_ndrt_trained int4 10 √ null
wash_rdrt_trained int4 10 √ null
wash_staff_at_branch int4 10 √ null
wash_staff_at_hq int4 10 √ null
wash_total_staff int4 10 √ null
nsi_annual_fdrs_reporting bool 1 √ null
nsi_branches int4 10 √ null
nsi_cmc_dashboard_compliance bool 1 √ null
nsi_domestically_generated_income bool 1 √ null
nsi_expenditures int4 10 √ null
nsi_gov_financial_support bool 1 √ null
nsi_income int4 10 √ null
nsi_policy_implementation bool 1 √ null
nsi_risk_management_framework bool 1 √ null
nsi_staff int4 10 √ null
nsi_trained_in_first_aid int4 10 √ null
nsi_volunteers int4 10 √ null
nsi_youth int4 10 √ null
fdrs varchar 6 √ null
additional_tab_name_ar varchar 100 √ null
additional_tab_name_en varchar 100 √ null
additional_tab_name_es varchar 100 √ null
additional_tab_name_fr varchar 100 √ null
disputed bool 1 null
sovereign_state_id int4 10 √ null
api_country.id api_country_sovereign_state_id_720e1e48_fk_api_country_idR
in_search bool 1 null
average_household_size numeric 5,2 √ null
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null
address_1 varchar 255 √ null
address_2 varchar 255 √ null
city_code varchar 255 √ null
phone varchar 255 √ null
website varchar 255 √ null
founded_date date 13 √ null
disaster_law_url varchar 255 √ null
emails _varchar 255 √ null

Indexes

Constraint Name Type Sort Column(s)
api_country_pkey Primary key Asc id
api_country_bbox_id Performance Asc bbox
api_country_centroid_id Performance Asc centroid
api_country_iso3_8bcd72f8_like Performance Asc iso3
api_country_iso3_8bcd72f8_uniq Must be unique Asc iso3
api_country_iso_6f2c023c_like Performance Asc iso
api_country_iso_6f2c023c_uniq Must be unique Asc iso
api_country_region_id_f142f638 Performance Asc region_id
api_country_sovereign_state_id_720e1e48 Performance Asc sovereign_state_id

Check Constraints

Constraint Name Constraint
api_country_wb_population_check ((wb_population >= 0))

Relationships

Close relationships within degrees of separation