data_area


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_id R
data_allegation_areas.area_id data_allegation_areas_area_id_e57d0e71_fk_data_area_id R
data_area.police_hq_id data_area_police_hq_id_a848cb39_fk_data_area_id R
data_racepopulation.area_id data_racepopulation_area_id_4ae23fb5_fk_data_area_id R
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_id R
description varchar 255 √ null
police_hq_id int4 10 √ null
data_area.id data_area_police_hq_id_a848cb39_fk_data_area_id R

Table contained 1551 rows

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