data_area

1551 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_area_id_seq'::regclass)
data_allegation.beat_id data_allegation_beat_id_3812d8f9_fk_data_area_idR
data_allegation_areas.area_id data_allegation_areas_area_id_e57d0e71_fk_data_area_idR
data_area.police_hq_id data_area_police_hq_id_a848cb39_fk_data_area_idR
data_policebeat.area_id data_policebeat_area_idR
data_racepopulation.area_id data_racepopulation_area_id_4ae23fb5_fk_data_area_idR
name varchar 100 null
area_type varchar 30 null
polygon geometry 2147483647 √ null
tags _varchar 20 null
median_income varchar 100 √ null
alderman varchar 255 √ null
commander_id int4 10 √ null
data_officer.id data_area_commander_id_45ac9547_fk_data_officer_idR
description varchar 255 √ null
police_hq_id int4 10 √ null
data_area.id data_area_police_hq_id_a848cb39_fk_data_area_idR
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
data_area_pkey Primary key Asc id
data_area_commander_id_45ac9547 Performance Asc commander_id
data_area_police_hq_id_a848cb39 Performance Asc police_hq_id
data_area_polygon_id Performance Asc polygon

Relationships

Close relationships within degrees of separation