data_officer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_officer_id_seq'::regclass)
data_area.commander_id data_area_commander_id_45ac9547_fk_data_officer_id R
data_award.officer_id data_award_officer_id_92c5d789_fk_data_officer_id R
data_investigator.officer_id data_investigator_officer_id_8095dac6_fk_data_officer_id R
data_involvement.officer_id data_involvement_officer_id_73520b64_fk_data_officer_id R
data_officeralias.new_officer_id data_officeralias_new_officer_id_4f38b294_fk_data_officer_id R
data_officerallegation.officer_id data_officerallegation_officer_id_a68f4888_fk_data_officer_id R
data_officerbadgenumber.officer_id data_officerbadgenumber_officer_id_c76d8363_fk_data_officer_id R
data_officerhistory.officer_id data_officerhistory_officer_id_db19fe27_fk_data_officer_id R
data_policewitness.officer_id data_policewitness_officer_id_8d0c044d_fk_data_officer_id R
data_salary.officer_id data_salary_officer_id_8d6c46ab_fk_data_officer_id R
trr_trr.officer_id trr_trr_officer_id_75e45524_fk_data_officer_id R
trr_trrstatus.officer_id trr_trrstatus_officer_id_e12565ea_fk_data_officer_id R
gender varchar 1 null
race varchar 50 null
appointed_date date 13 √ null
rank varchar 100 null
active varchar 10 null
birth_year int4 10 √ null
first_name varchar 255 null
last_name varchar 255 null
tags _varchar 20 null
middle_initial varchar 5 √ null
suffix_name varchar 5 √ null
resignation_date date 13 √ null
complaint_percentile numeric 6,4 √ null
middle_initial2 varchar 5 √ null
civilian_allegation_percentile numeric 6,4 √ null
honorable_mention_percentile numeric 6,4 √ null
internal_allegation_percentile numeric 6,4 √ null
trr_percentile numeric 6,4 √ null

Table contained 33671 rows

Indexes

Constraint Name Type Sort Column(s)
data_officer_pkey Primary key Asc id
data_officer_2a034e9d Performance Asc first_name
data_officer_7d4553c0 Performance Asc last_name

Relationships

Close relationships within degrees of separation