data_policeunit

272 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_policeunit_id_seq'::regclass)
data_investigatorallegation.current_unit_id data_investigatorall_current_unit_id_da1ab9e3_fk_data_poliR
data_officer.last_unit_id data_officer_last_unit_id_b746c190_fk_data_policeunit_idR
data_officerassignmentattendance.unit_id data_officerassignmentattendance_unit_keyR
data_officerhistory.unit_id data_officerhistory_unit_id_c33c0072_fk_data_policeunit_idR
data_policebeat.unit_id data_policebeat_unit_idR
data_searchwarrant.policeunit_id data_searchwarrant_unit_idR
trr_trr.officer_unit_detail_id trr_trr_officer_unit_detail_id_3db18cbd_fk_data_policeunit_idR
trr_trr.officer_unit_id trr_trr_officer_unit_id_fc0d7ceb_fk_data_policeunit_idR
unit_name varchar 5 null
description varchar 255 √ null
tags _varchar 20 null
active bool 1 √ null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
data_policeunit_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation