113 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| pinboard_pinboard_of_pinboard_id_c0adeb41_fk_pinboard_ |
|
|
Restrict delete | ||
| pinboard_pinboard_of_officer_id_b8e61da0_fk_data_offi |
|
|
Restrict delete | ||
| activity_grid_activi_officer2_id_d2859ea2_fk_data_offi |
|
|
Restrict delete | ||
| activity_grid_activi_officer1_id_291beefe_fk_data_offi |
|
|
Restrict delete | ||
| twitterbot_twitterbo_response_log_id_50936d5c_fk_twitterbo |
|
|
Restrict delete | ||
| data_officeryearlype_officer_id_310c59d7_fk_data_offi |
|
|
Restrict delete | ||
| pinboard_pinboard_al_pinboard_id_58abb7ed_fk_pinboard_ |
|
|
Restrict delete | ||
| pinboard_pinboard_al_allegation_id_6444fd6c_fk_data_alle |
|
|
Restrict delete | ||
| data_attachmentfile_last_updated_by_id_061dfbf8_fk_auth_user_id |
|
|
Restrict delete | ||
| data_attachmentfile_allegation_id_1b6443a8_fk_data_alle |
|
|
Restrict delete | ||
| data_attachmentfile_owner_type_id_ca124790_fk_django_co |
|
|
Restrict delete | ||
| wagtailcore_pagerevisio_page_id_d421cc1d_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| wagtailcore_pagerevision_user_id_2409d2f4_fk_auth_user_id |
|
|
Restrict delete | ||
| wagtailredirects_redire_site_id_780a0e1e_fk_wagtailcore_site_id |
|
|
Restrict delete | ||
| wagtailredirec_redirect_page_id_b5728a8f_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| taggit_tagge_content_type_id_9957a03c_fk_django_content_type_id |
|
|
Restrict delete | ||
| taggit_taggeditem_tag_id_f4f5b767_fk_taggit_tag_id |
|
|
Restrict delete | ||
| data_area_commander_id_45ac9547_fk_data_officer_id |
|
|
Restrict delete | ||
| data_area_police_hq_id_a848cb39_fk_data_area_id |
|
|
Restrict delete | ||
| data_racepopulation_area_id_4ae23fb5_fk_data_area_id |
|
|
Restrict delete | ||
| data_salary_officer_id_8d6c46ab_fk_data_officer_id |
|
|
Restrict delete | ||
| pinboard_pinboard_source_pinboard_id_f21df3fd_fk_pinboard_ |
|
|
Restrict delete | ||
| wagtailsearch_query_query_id_2185994b_fk_wagtailsearch_query_id |
|
|
Restrict delete | ||
| data_allegation_line_linearea_id_b5b1b663_fk_data_line |
|
|
Restrict delete | ||
| data_allegation_line_allegation_id_6c00ce82_fk_data_alle |
|
|
Restrict delete | ||
| pinboard_pinboard_tr_pinboard_id_d3dc3f09_fk_pinboard_ |
|
|
Restrict delete | ||
| pinboard_pinboard_trrs_trr_id_57fb089d_fk_trr_trr_id |
|
|
Restrict delete | ||
| trr_charge_trr_id_983da4e1_fk_trr_trr_id |
|
|
Restrict delete | ||
| data_attachmentreque_allegation_id_c0b1886b_fk_data_alle |
|
|
Restrict delete | ||
| trr_trr_officer_unit_detail_id_3db18cbd_fk_data_policeunit_id |
|
|
Restrict delete | ||
| trr_trr_officer_unit_id_fc0d7ceb_fk_data_policeunit_id |
|
|
Restrict delete | ||
| trr_trr_officer_id_75e45524_fk_data_officer_id |
|
|
Restrict delete | ||
| pinboard_examplepinb_pinboard_id_e62bd59e_fk_pinboard_ |
|
|
Restrict delete | ||
| wagtailforms_formsubmis_page_id_e48e93e7_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| data_searchwarrant_unit_id |
|
|
Restrict delete | ||
| sw_crid_fkey |
|
|
Restrict delete | ||
| data_officer_last_unit_id_b746c190_fk_data_policeunit_id |
|
|
Restrict delete | ||
| activity_grid_activi_officer_id_c2b4881b_fk_data_offi |
|
|
Restrict delete | ||
| data_officerbadgenumber_officer_id_c76d8363_fk_data_officer_id |
|
|
Restrict delete | ||
| data_officerassignmentattendance_unit_key |
|
|
Restrict delete | ||
| data_officerassignmentattendance_beat_key |
|
|
Restrict delete | ||
| data_officerassignmentattendance_officer_key |
|
|
Restrict delete | ||
| lawsuit_payment_lawsuit_id_57266881_fk_lawsuit_lawsuit_id |
|
|
Restrict delete | ||
| wagtailcore_pageviewres_page_id_15a8bea6_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| wagtailcore_page_owner_id_fbf7c332_fk_auth_user_id |
|
|
Restrict delete | ||
| wagtailcore__content_type_id_c28424df_fk_django_content_type_id |
|
|
Restrict delete | ||
| data_investigatorall_current_unit_id_da1ab9e3_fk_data_poli |
|
|
Restrict delete | ||
| data_investigatorall_allegation_id_655b5938_fk_data_alle |
|
|
Restrict delete | ||
| data_investigatorall_investigator_id_cd1fd6b1_fk_data_inve |
|
|
Restrict delete | ||
| auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id |
|
|
Restrict delete | ||
| auth_group_permissions_group_id_b120cbf9_fk_auth_group_id |
|
|
Restrict delete | ||
| data_complainant_allegation_id_f5452147_fk_data_allegation_crid |
|
|
Restrict delete | ||
| data_award_officer_id_92c5d789_fk_data_officer_id |
|
|
Restrict delete | ||
| trr_trrstatus_officer_id_e12565ea_fk_data_officer_id |
|
|
Restrict delete | ||
| trr_trrstatus_trr_id_3285fe79_fk_trr_trr_id |
|
|
Restrict delete | ||
| data_officerallegati_allegation_id_429ce710_fk_data_alle |
|
|
Restrict delete | ||
| data_officerallegation_officer_id_a68f4888_fk_data_officer_id |
|
|
Restrict delete | ||
| data_officerallegati_allegation_category__023a83f1_fk_data_alle |
|
|
Restrict delete | ||
| data_attachmentnarra_attachment_id_2586f1f8_fk_data_atta |
|
|
Restrict delete | ||
| data_officerrank_rank_id |
|
|
Restrict delete | ||
| data_officerrank_officer_id |
|
|
Restrict delete | ||
| data_attachmentocr_attachment_id_fd91a419_fk_data_atta |
|
|
Restrict delete | ||
| activity_log_activit_modified_object_type_e69cedb3_fk_django_co |
|
|
Restrict delete | ||
| activity_log_activitylog_user_id_facfa596_fk_auth_user_id |
|
|
Restrict delete | ||
| authtoken_token_user_id_35299eff_fk_auth_user_id |
|
|
Restrict delete | ||
| lawsuit_lawsuitplain_lawsuit_id_46f0aed9_fk_lawsuit_l |
|
|
Restrict delete | ||
| wagtailsearch_editorspi_page_id_28cbc274_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| wagtailsearch_edito_query_id_c6eee4a0_fk_wagtailsearch_query_id |
|
|
Restrict delete | ||
| wagtaildocs_docume_uploaded_by_user_id_17258b41_fk_auth_user_id |
|
|
Restrict delete | ||
| wagtaildocs_collection_id_23881625_fk_wagtailcore_collection_id |
|
|
Restrict delete | ||
| data_investigator_officer_id_8095dac6_fk_data_officer_id |
|
|
Restrict delete | ||
| wagtailimag_collection_id_c2f8af7e_fk_wagtailcore_collection_id |
|
|
Restrict delete | ||
| wagtailimages_imag_uploaded_by_user_id_5d73dc75_fk_auth_user_id |
|
|
Restrict delete | ||
| auth_user_groups_group_id_97559544_fk_auth_group_id |
|
|
Restrict delete | ||
| auth_user_groups_user_id_6a12ed8b_fk_auth_user_id |
|
|
Restrict delete | ||
| data_officerhistory_officer_id_db19fe27_fk_data_officer_id |
|
|
Restrict delete | ||
| data_officerhistory_unit_id_c33c0072_fk_data_policeunit_id |
|
|
Restrict delete | ||
| lawsuit_lawsuit_officers_officer_id_361b7661_fk_data_officer_id |
|
|
Restrict delete | ||
| lawsuit_lawsuit_offi_lawsuit_id_5037a35c_fk_lawsuit_l |
|
|
Restrict delete | ||
| trr_subjectweapon_trr_id_bac23e40_fk_trr_trr_id |
|
|
Restrict delete | ||
| trr_trrattachmentrequest_trr_id_0bd4c51e_fk_trr_trr_id |
|
|
Restrict delete | ||
| wagtailimages_ren_filter_id_7fc52567_fk_wagtailimages_filter_id |
|
|
Restrict delete | ||
| wagtailimages_rendi_image_id_3e1fd774_fk_wagtailimages_image_id |
|
|
Restrict delete | ||
| django_admin_content_type_id_c4bce8eb_fk_django_content_type_id |
|
|
Restrict delete | ||
| django_admin_log_user_id_c564eba6_fk_auth_user_id |
|
|
Restrict delete | ||
| wagtailusers_userprofile_user_id_59c92331_fk_auth_user_id |
|
|
Restrict delete | ||
| data_attachmentfile__attachmentfile_id_2f07157b_fk_data_atta |
|
|
Restrict delete | ||
| data_attachmentfile_tags_tag_id_095fb833_fk_data_tag_id |
|
|
Restrict delete | ||
| analytics_attachment_attachment_file_id_be5b1f6c_fk_data_atta |
|
|
Restrict delete | ||
| data_allegation_beat_id_3812d8f9_fk_data_area_id |
|
|
Restrict delete | ||
| data_allegation_most_common_category_88004da7_fk_data_alle |
|
|
Restrict delete | ||
| wagtailcore_site_root_page_id_e02fb95c_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| data_allegation_area_allegation_id_1ccd7982_fk_data_alle |
|
|
Restrict delete | ||
| data_allegation_areas_area_id_e57d0e71_fk_data_area_id |
|
|
Restrict delete | ||
| search_terms_searcht_category_id_64649515_fk_search_te |
|
|
Restrict delete | ||
| data_officeralias_new_officer_id_4f38b294_fk_data_officer_id |
|
|
Restrict delete | ||
| data_victim_allegation_id_bef5a29d_fk_data_allegation_crid |
|
|
Restrict delete | ||
| data_policebeat_unit_id |
|
|
Restrict delete | ||
| data_policebeat_area_id |
|
|
Restrict delete | ||
| trr_weapondischarge_trr_id_a259df23_fk_trr_trr_id |
|
|
Restrict delete | ||
| auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id |
|
|
Restrict delete | ||
| auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id |
|
|
Restrict delete | ||
| trr_actionresponse_trr_id_59e4c15b_fk_trr_trr_id |
|
|
Restrict delete | ||
| data_policewitness_officer_id_8d0c044d_fk_data_officer_id |
|
|
Restrict delete | ||
| data_policewitness_allegation_id_b8dc2d75_fk_data_alle |
|
|
Restrict delete | ||
| wagtailcore_groupcollectionp_group_id_05d61460_fk_auth_group_id |
|
|
Restrict delete | ||
| wagtailcore_collection_id_5423575a_fk_wagtailcore_collection_id |
|
|
Restrict delete | ||
| wagtailcore_groupc_permission_id_1b626275_fk_auth_permission_id |
|
|
Restrict delete | ||
| data_involvement_officer_id_73520b64_fk_data_officer_id |
|
|
Restrict delete | ||
| data_involvement_allegation_id_c248e036_fk_data_allegation_crid |
|
|
Restrict delete | ||
| wagtailcore_grouppagepermiss_group_id_fc07e671_fk_auth_group_id |
|
|
Restrict delete | ||
| wagtailcore_grouppagepe_page_id_710b114a_fk_wagtailcore_page_id |
|
|
Restrict delete | ||
| auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| data_racepopulation | data_racepopulation_count_check | ((count >= 0)) |
| data_salary | data_salary_age_at_hire_check | ((age_at_hire >= 0)) |
| data_salary | data_salary_salary_check | ((salary >= 0)) |
| data_salary | data_salary_year_check | ((year >= 0)) |
| twitterbot_tweetresponseroundrobin | twitterbot_tweetresponseroundrobin_last_index_check | ((last_index >= 0)) |
| trr_charge | trr_charge_sr_no_check | ((sr_no >= 0)) |
| trr_charge | trr_charge_subject_no_check | ((subject_no >= 0)) |
| trr_trr | trr_trr_beat_check | ((beat >= 0)) |
| trr_trr | trr_trr_number_of_officers_using_firearm_check | ((number_of_officers_using_firearm >= 0)) |
| trr_trr | trr_trr_number_of_weapons_discharged_check | ((number_of_weapons_discharged >= 0)) |
| trr_trr | trr_trr_subject_age_check | ((subject_age >= 0)) |
| trr_trr | trr_trr_subject_birth_year_check | ((subject_birth_year >= 0)) |
| trr_trr | trr_trr_subject_id_check | ((subject_id >= 0)) |
| trr_trr | trr_trr_total_number_of_shots_check | ((total_number_of_shots >= 0)) |
| data_officer | data_officer_current_salary_check | ((current_salary >= 0)) |
| search_terms_searchtermcategory | search_terms_searchtermcategory_order_number_check | ((order_number >= 0)) |
| analytics_searchtracking | analytics_searchtracking_results_check | ((results >= 0)) |
| analytics_searchtracking | analytics_searchtracking_usages_check | ((usages >= 0)) |
| wagtailcore_page | wagtailcore_page_depth_check | ((depth >= 0)) |
| wagtailcore_page | wagtailcore_page_numchild_check | ((numchild >= 0)) |
| wagtailcore_collection | wagtailcore_collection_depth_check | ((depth >= 0)) |
| wagtailcore_collection | wagtailcore_collection_numchild_check | ((numchild >= 0)) |
| activity_log_activitylog | activity_log_activitylog_modified_object_id_check | ((modified_object_id >= 0)) |
| wagtailimages_image | wagtailimages_image_file_size_check | ((file_size >= 0)) |
| wagtailimages_image | wagtailimages_image_focal_point_height_check | ((focal_point_height >= 0)) |
| wagtailimages_image | wagtailimages_image_focal_point_width_check | ((focal_point_width >= 0)) |
| wagtailimages_image | wagtailimages_image_focal_point_x_check | ((focal_point_x >= 0)) |
| wagtailimages_image | wagtailimages_image_focal_point_y_check | ((focal_point_y >= 0)) |
| spatial_ref_sys | spatial_ref_sys_srid_check | (((srid > 0) AND (srid <= 998999))) |
| django_admin_log | django_admin_log_action_flag_check | ((action_flag >= 0)) |
| search_terms_searchtermitem | search_terms_searchtermitem_order_number_check | ((order_number >= 0)) |