local_units_localunit

7511 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('local_units_localunit_id_seq'::regclass)
local_units_localunitchangerequest.local_unit_id local_units_localuni_local_unit_id_5cf99899_fk_local_uniR
local_branch_name varchar 255 √ null
english_branch_name varchar 255 √ null
created_at timestamptz 35,6 null
modified_at timestamptz 35,6 null
draft bool 1 null
source_en varchar 500 √ null
source_loc varchar 500 √ null
address_loc varchar 500 √ null
address_en varchar 500 √ null
city_loc varchar 255 √ null
city_en varchar 255 √ null
focal_person_loc varchar 255 √ null
focal_person_en varchar 255 √ null
postcode varchar 10 √ null
phone varchar 30 √ null
email varchar 255 √ null
link varchar 255 √ null
location geometry 2147483647 null
country_id int4 10 null
api_country.id local_units_localunit_country_id_46e84ce1_fk_api_country_idR
type_id int8 19 null
local_units_localunittype.id local_units_localuni_type_id_88564b58_fk_local_uniR
subtype varchar 200 √ null
level_id int8 19 √ null
local_units_localunitlevel.id local_units_localuni_level_id_748ea2c3_fk_local_uniR
date_of_data date 13 null
health_id int8 19 √ null
local_units_healthdata.id local_units_localuni_health_id_ad8076af_fk_local_uniR
visibility int4 10 null
created_by_id int4 10 √ null
auth_user.id local_units_localunit_created_by_id_29b69805_fk_auth_user_idR
modified_by_id int4 10 √ null
auth_user.id local_units_localunit_modified_by_id_a3880f42_fk_auth_user_idR
deprecated_reason int4 10 √ null
deprecated_reason_overview text 2147483647 √ null
is_deprecated bool 1 null
last_sent_validator_type int4 10 null
status int4 10 null
update_reason_overview text 2147483647 √ null
bulk_upload_id int8 19 √ null
local_units_localunitbulkupload.id local_units_localuni_bulk_upload_id_011b6166_fk_local_uniR

Indexes

Constraint Name Type Sort Column(s)
local_units_localunit_pkey Primary key Asc id
local_units_localunit_bulk_upload_id_011b6166 Performance Asc bulk_upload_id
local_units_localunit_country_id_46e84ce1 Performance Asc country_id
local_units_localunit_created_by_id_29b69805 Performance Asc created_by_id
local_units_localunit_health_id_ad8076af Performance Asc health_id
local_units_localunit_level_id_748ea2c3 Performance Asc level_id
local_units_localunit_location_id Performance Asc location
local_units_localunit_modified_by_id_a3880f42 Performance Asc modified_by_id
local_units_localunit_type_id_88564b58 Performance Asc type_id

Relationships

Close relationships within degrees of separation