api_district

3759 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_district_id_seq'::regclass)
api_admin2.admin1_id api_admin2_admin1_id_2e3b14f4_fk_api_district_idR
api_districtgeoms.district_id api_districtgeoms_district_id_b9141060_fk_api_district_idR
api_event_districts.district_id api_event_districts_district_id_00ec8524_fk_api_district_idR
api_fieldreport_districts.district_id api_fieldreport_dist_district_id_6775a365_fk_api_distrR
deployments_emergencyproject_districts.district_id deployments_emergenc_district_id_03c6870e_fk_api_distrR
deployments_partnersocietydeployment_district_deployed_to.district_id deployments_partners_district_id_55bb8774_fk_api_distrR
deployments_project_project_districts.district_id deployments_project__district_id_f72451b2_fk_api_distrR
dref_dref_district.district_id dref_dref_district_district_id_bb59686d_fk_api_district_idR
dref_dreffinalreport_district.district_id dref_dreffinalreport_district_id_e1c0f2bc_fk_api_distrR
dref_drefoperationalupdate_district.district_id dref_drefoperational_district_id_70d52c42_fk_api_distrR
eap_eap.district_id eap_eap_district_id_aeb90180_fk_api_district_idR
flash_update_flashcountrydistrict_district.district_id flash_update_flashco_district_id_b49594a0_fk_api_distrR
name varchar 100 null
code varchar 10 null
country_id int4 10 √ null
api_country.id api_district_country_id_b4999656_fk_api_country_idR
is_enclave bool 1 null
wb_population int4 10 √ null
wb_year varchar 4 √ null
bbox geometry 2147483647 √ null
centroid geometry 2147483647 √ null
is_deprecated bool 1 null

Indexes

Constraint Name Type Sort Column(s)
api_district_pkey Primary key Asc id
api_district_bbox_id Performance Asc bbox
api_district_centroid_id Performance Asc centroid
api_district_country_id_b4999656 Performance Asc country_id

Check Constraints

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

Relationships

Close relationships within degrees of separation