api_region

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_region_id_seq'::regclass)
api_appeal.region_id api_appeal_region_id_2119ea34_fk_api_region_idR
api_appealhistory.region_id api_appealhistory_region_id_021d21f5_fk_api_region_idR
api_country.region_id api_country_region_id_f142f638_fk_api_region_idR
api_event_regions.region_id api_event_regions_region_id_fb335986_fk_api_region_idR
api_fieldreport_regions.region_id api_fieldreport_regions_region_id_6f3346e7_fk_api_region_idR
api_regioncontact.region_id api_regioncontact_region_id_2e2bc127_fk_api_region_idR
api_regionemergencysnippet.region_id api_regionemergencysnippet_region_id_5f1a27aa_fk_api_region_idR
api_regionkeyfigure.region_id api_regionkeyfigure_region_id_7ba79953_fk_api_region_idR
api_regionlink.region_id api_regionlink_region_id_5a6caf22_fk_api_region_idR
api_regionpreparednesssnippet.region_id api_regionpreparedne_region_id_c7e22b4b_fk_api_regioR
api_regionprofilesnippet.region_id api_regionprofilesnippet_region_id_70fd1608_fk_api_region_idR
api_regionsnippet.region_id api_regionsnippet_region_id_ad718d86_fk_api_region_idR
api_userregion.region_id api_userregion_region_id_7c16b98f_fk_api_region_idR
deployments_fact.region_id deployments_fact_region_id_cdd84270_fk_api_region_idR
deployments_heop.region_id deployments_heop_region_id_bd316224_fk_api_region_idR
deployments_personneldeployment.region_deployed_to_id deployments_personne_region_deployed_to_i_e7cf7745_fk_api_regioR
deployments_rdrt.region_id deployments_rdrt_region_id_a71f2b58_fk_api_region_idR
notifications_subscription.region_id notifications_subscription_region_id_9f35d6f7_fk_api_region_idR
name int4 10 null
bbox geometry 2147483647 √ null
label varchar 250 null
label_ar varchar 250 √ null
label_en varchar 250 √ null
label_es varchar 250 √ null
label_fr varchar 250 √ null
additional_tab_name varchar 100 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
translation_module_original_language varchar 2 null
translation_module_skip_auto_translation bool 1 null

Indexes

Constraint Name Type Sort Column(s)
api_region_pkey Primary key Asc id
api_region_bbox_id Performance Asc bbox

Relationships

Close relationships within degrees of separation