api_admin2

1400 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('api_admin2_id_seq'::regclass)
api_admin2geoms.admin2_id api_admin2geoms_admin2_id_90b561c7_fk_api_admin2_idR
deployments_emergencyproject_admin2.admin2_id deployments_emergenc_admin2_id_68e58655_fk_api_adminR
deployments_project_project_admin2.admin2_id deployments_project__admin2_id_0cb363ee_fk_api_adminR
name varchar 100 null
code varchar 64 null
centroid geometry 2147483647 √ null
bbox geometry 2147483647 √ null
admin1_id int4 10 null
api_district.id api_admin2_admin1_id_2e3b14f4_fk_api_district_idR
alternate_name varchar 100 √ null
alternate_name_code varchar 10 √ null
local_name varchar 100 √ null
local_name_code varchar 10 √ null
created_at timestamptz 35,6 null
is_deprecated bool 1 null

Indexes

Constraint Name Type Sort Column(s)
api_admin2_pkey Primary key Asc id
api_admin2_admin1_id_2e3b14f4 Performance Asc admin1_id
api_admin2_bbox_id Performance Asc bbox
api_admin2_centroid_id Performance Asc centroid
api_admin2_code_eb1ed5de_like Performance Asc code
api_admin2_code_key Must be unique Asc code

Relationships

Close relationships within degrees of separation