data_officer

35545 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('data_officer_id_seq'::regclass)
activity_grid_activitycard.officer_id activity_grid_activi_officer_id_c2b4881b_fk_data_offiR
activity_grid_activitypaircard.officer1_id activity_grid_activi_officer1_id_291beefe_fk_data_offiR
activity_grid_activitypaircard.officer2_id activity_grid_activi_officer2_id_d2859ea2_fk_data_offiR
data_area.commander_id data_area_commander_id_45ac9547_fk_data_officer_idR
data_award.officer_id data_award_officer_id_92c5d789_fk_data_officer_idR
data_investigator.officer_id data_investigator_officer_id_8095dac6_fk_data_officer_idR
data_involvement.officer_id data_involvement_officer_id_73520b64_fk_data_officer_idR
data_officeralias.new_officer_id data_officeralias_new_officer_id_4f38b294_fk_data_officer_idR
data_officerallegation.officer_id data_officerallegation_officer_id_a68f4888_fk_data_officer_idR
data_officerassignmentattendance.officer_id data_officerassignmentattendance_officer_keyR
data_officerbadgenumber.officer_id data_officerbadgenumber_officer_id_c76d8363_fk_data_officer_idR
data_officerhistory.officer_id data_officerhistory_officer_id_db19fe27_fk_data_officer_idR
data_officerrank.officer_id data_officerrank_officer_idR
data_officeryearlypercentile.officer_id data_officeryearlype_officer_id_310c59d7_fk_data_offiR
data_policewitness.officer_id data_policewitness_officer_id_8d0c044d_fk_data_officer_idR
data_salary.officer_id data_salary_officer_id_8d6c46ab_fk_data_officer_idR
lawsuit_lawsuit_officers.officer_id lawsuit_lawsuit_officers_officer_id_361b7661_fk_data_officer_idR
pinboard_pinboard_officers.officer_id pinboard_pinboard_of_officer_id_b8e61da0_fk_data_offiR
trr_trr.officer_id trr_trr_officer_id_75e45524_fk_data_officer_idR
trr_trrstatus.officer_id trr_trrstatus_officer_id_e12565ea_fk_data_officer_idR
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
allegation_count int4 10 √ null
sustained_count int4 10 √ null
civilian_compliment_count int4 10 √ null
current_badge varchar 10 √ null
current_salary int4 10 √ null
discipline_count int4 10 √ null
honorable_mention_count int4 10 √ null
last_unit_id int4 10 √ null
data_policeunit.id data_officer_last_unit_id_b746c190_fk_data_policeunit_idR
major_award_count int4 10 √ null
trr_count int4 10 √ null
unsustained_count int4 10 √ null
has_unique_name bool 1 null
created_at timestamptz 35,6 null
updated_at timestamptz 35,6 null

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
data_officer_last_unit_id_b746c190 Performance Asc last_unit_id

Check Constraints

Constraint Name Constraint
data_officer_current_salary_check ((current_salary >= 0))

Relationships

Close relationships within degrees of separation