trr_trr


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('trr_trr_id_seq'::regclass)
trr_actionresponse.trr_id trr_actionresponse_trr_id_59e4c15b_fk_trr_trr_id R
trr_charge.trr_id trr_charge_trr_id_983da4e1_fk_trr_trr_id R
trr_subjectweapon.trr_id trr_subjectweapon_trr_id_bac23e40_fk_trr_trr_id R
trr_trrattachmentrequest.trr_id trr_trrattachmentrequest_trr_id_0bd4c51e_fk_trr_trr_id R
trr_trrstatus.trr_id trr_trrstatus_trr_id_3285fe79_fk_trr_trr_id R
trr_weapondischarge.trr_id trr_weapondischarge_trr_id_a259df23_fk_trr_trr_id R
beat int2 5 √ null
block varchar 8 √ null
direction varchar 8 √ null
street varchar 64 √ null
location varchar 64 √ null
trr_datetime timestamptz 35,6 √ null
indoor_or_outdoor varchar 8 √ null
lighting_condition varchar 32 √ null
weather_condition varchar 32 √ null
notify_OEMC bool 1 √ null
notify_district_sergeant bool 1 √ null
notify_OP_command bool 1 √ null
notify_DET_division bool 1 √ null
number_of_weapons_discharged int2 5 √ null
party_fired_first varchar 16 √ null
location_recode varchar 64 √ null
taser bool 1 √ null
total_number_of_shots int2 5 √ null
firearm_used bool 1 √ null
number_of_officers_using_firearm int2 5 √ null
officer_assigned_beat varchar 16 √ null
officer_on_duty bool 1 √ null
officer_in_uniform bool 1 √ null
officer_injured bool 1 √ null
officer_rank varchar 32 √ null
subject_id int4 10 √ null
subject_armed bool 1 √ null
subject_injured bool 1 √ null
subject_alleged_injury bool 1 √ null
subject_age int2 5 √ null
subject_birth_year int2 5 √ null
subject_gender varchar 1 √ null
subject_race varchar 32 √ null
officer_id int4 10 √ null
data_officer.id trr_trr_officer_id_75e45524_fk_data_officer_id R
officer_unit_id int4 10 √ null
data_policeunit.id trr_trr_officer_unit_id_fc0d7ceb_fk_data_policeunit_id R
officer_unit_detail_id int4 10 √ null
data_policeunit.id trr_trr_officer_unit_detail_id_3db18cbd_fk_data_policeunit_id R
point geometry 2147483647 √ null

Table contained 67019 rows

Indexes

Constraint Name Type Sort Column(s)
trr_trr_pkey Primary key Asc id
trr_trr_officer_id_75e45524 Performance Asc officer_id
trr_trr_officer_unit_detail_id_3db18cbd Performance Asc officer_unit_detail_id
trr_trr_officer_unit_id_fc0d7ceb Performance Asc officer_unit_id
trr_trr_point_id Performance Asc point

Relationships

Close relationships within degrees of separation