Constraints

39 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
trr_trrstatus_officer_id_e12565ea_fk_data_officer_id
trr_trrstatus.officer_id
data_officer.id
Restrict delete
trr_trrstatus_trr_id_3285fe79_fk_trr_trr_id
trr_trrstatus.trr_id
trr_trr.id
Restrict delete
trr_charge_trr_id_983da4e1_fk_trr_trr_id
trr_charge.trr_id
trr_trr.id
Restrict delete
data_attachmentreque_allegation_id_c0b1886b_fk_data_alle
data_attachmentrequest.allegation_id
data_allegation.id
Restrict delete
trr_trr_officer_unit_detail_id_3db18cbd_fk_data_policeunit_id
trr_trr.officer_unit_detail_id
data_policeunit.id
Restrict delete
trr_trr_officer_unit_id_fc0d7ceb_fk_data_policeunit_id
trr_trr.officer_unit_id
data_policeunit.id
Restrict delete
trr_trr_officer_id_75e45524_fk_data_officer_id
trr_trr.officer_id
data_officer.id
Restrict delete
trr_trrattachmentrequest_trr_id_0bd4c51e_fk_trr_trr_id
trr_trrattachmentrequest.trr_id
trr_trr.id
Restrict delete
d_allegation_category_id_023a83f1_fk_data_allegationcategory_id
data_officerallegation.allegation_category_id
data_allegationcategory.id
Restrict delete
data_officerallega_allegation_id_429ce710_fk_data_allegation_id
data_officerallegation.allegation_id
data_allegation.id
Restrict delete
data_officerallegation_officer_id_a68f4888_fk_data_officer_id
data_officerallegation.officer_id
data_officer.id
Restrict delete
data_allegation_beat_id_3812d8f9_fk_data_area_id
data_allegation.beat_id
data_area.id
Restrict delete
data_attachmentfil_allegation_id_1b6443a8_fk_data_allegation_id
data_attachmentfile.allegation_id
data_allegation.id
Restrict delete
data_allegation_ar_allegation_id_1ccd7982_fk_data_allegation_id
data_allegation_areas.allegation_id
data_allegation.id
Restrict delete
data_allegation_areas_area_id_e57d0e71_fk_data_area_id
data_allegation_areas.area_id
data_area.id
Restrict delete
data_officerbadgenumber_officer_id_c76d8363_fk_data_officer_id
data_officerbadgenumber.officer_id
data_officer.id
Restrict delete
data_officeralias_new_officer_id_4f38b294_fk_data_officer_id
data_officeralias.new_officer_id
data_officer.id
Restrict delete
data_victim_allegation_id_bef5a29d_fk_data_allegation_id
data_victim.allegation_id
data_allegation.id
Restrict delete
trr_weapondischarge_trr_id_a259df23_fk_trr_trr_id
trr_weapondischarge.trr_id
trr_trr.id
Restrict delete
data_area_commander_id_45ac9547_fk_data_officer_id
data_area.commander_id
data_officer.id
Restrict delete
data_area_police_hq_id_a848cb39_fk_data_area_id
data_area.police_hq_id
data_area.id
Restrict delete
trr_actionresponse_trr_id_59e4c15b_fk_trr_trr_id
trr_actionresponse.trr_id
trr_trr.id
Restrict delete
data_policewitness_allegation_id_b8dc2d75_fk_data_allegation_id
data_policewitness.allegation_id
data_allegation.id
Restrict delete
data_policewitness_officer_id_8d0c044d_fk_data_officer_id
data_policewitness.officer_id
data_officer.id
Restrict delete
data_racepopulation_area_id_4ae23fb5_fk_data_area_id
data_racepopulation.area_id
data_area.id
Restrict delete
data_involvement_allegation_id_c248e036_fk_data_allegation_id
data_involvement.allegation_id
data_allegation.id
Restrict delete
data_involvement_officer_id_73520b64_fk_data_officer_id
data_involvement.officer_id
data_officer.id
Restrict delete
data_investigator_officer_id_8095dac6_fk_data_officer_id
data_investigator.officer_id
data_officer.id
Restrict delete
data_salary_officer_id_8d6c46ab_fk_data_officer_id
data_salary.officer_id
data_officer.id
Restrict delete
data_investigatorall_current_unit_id_da1ab9e3_fk_data_poli
data_investigatorallegation.current_unit_id
data_policeunit.id
Restrict delete
data_investigatorall_allegation_id_655b5938_fk_data_alle
data_investigatorallegation.allegation_id
data_allegation.id
Restrict delete
data_investigatorall_investigator_id_cd1fd6b1_fk_data_inve
data_investigatorallegation.investigator_id
data_investigator.id
Restrict delete
data_allegation_line_a_linearea_id_b5b1b663_fk_data_linearea_id
data_allegation_line_areas.linearea_id
data_linearea.id
Restrict delete
data_allegation_li_allegation_id_6c00ce82_fk_data_allegation_id
data_allegation_line_areas.allegation_id
data_allegation.id
Restrict delete
data_officerhistory_officer_id_db19fe27_fk_data_officer_id
data_officerhistory.officer_id
data_officer.id
Restrict delete
data_officerhistory_unit_id_c33c0072_fk_data_policeunit_id
data_officerhistory.unit_id
data_policeunit.id
Restrict delete
data_complainant_allegation_id_f5452147_fk_data_allegation_id
data_complainant.allegation_id
data_allegation.id
Restrict delete
data_award_officer_id_92c5d789_fk_data_officer_id
data_award.officer_id
data_officer.id
Restrict delete
trr_subjectweapon_trr_id_bac23e40_fk_trr_trr_id
trr_subjectweapon.trr_id
trr_trr.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected