195 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| change_log_units_record_id_fkey |
|
|
Cascade on delete | ||
| change_log_units_edits_record_id_fkey |
|
|
Cascade on delete | ||
| crashes_edits_rpt_cris_cnty_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_surf_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_obj_struck_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_rpt_sec_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_rpt_sec_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_wthr_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_id_fkey |
|
|
Cascade on delete | ||
| crashes_edits_rpt_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_investigat_agency_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_traffic_cntl_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_light_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_rpt_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_rpt_city_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_fhe_collsn_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_intrsct_relat_id_fkey |
|
|
Restrict delete | ||
| crashes_edits_surf_type_id_fkey |
|
|
Restrict delete | ||
| change_log_crashes_record_id_fkey |
|
|
Cascade on delete | ||
| recommendations_recommendation_status_id_fkey |
|
|
Restrict delete | ||
| recommendations_crashes_pk_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_obj_struck_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_city_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_cris_cnty_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_fhe_collsn_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_surf_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_investigat_agency_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_surf_type_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_wthr_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_light_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_intrsct_relat_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_sec_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_rpt_sec_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_cris_traffic_cntl_id_fkey |
|
|
Restrict delete | ||
| change_log_people_record_id_fkey |
|
|
Cascade on delete | ||
| crashes_surf_type_id_fkey |
|
|
Restrict delete | ||
| crashes_wthr_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_traffic_cntl_id_fkey |
|
|
Restrict delete | ||
| crashes_investigat_agency_id_fkey |
|
|
Restrict delete | ||
| crashes_rpt_sec_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_fhe_collsn_id_fkey |
|
|
Restrict delete | ||
| crashes_intrsct_relat_id_fkey |
|
|
Restrict delete | ||
| crashes_rpt_sec_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_id_fkey |
|
|
Cascade on delete | ||
| crashes_rpt_cris_cnty_id_fkey |
|
|
Restrict delete | ||
| crashes_rpt_road_part_id_fkey |
|
|
Restrict delete | ||
| crashes_location_id_fkey |
|
|
Null on delete | ||
| crashes_engineering_area_fkey |
|
|
Null on delete | ||
| crashes_rpt_rdwy_sys_id_fkey |
|
|
Restrict delete | ||
| crashes_light_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_surf_cond_id_fkey |
|
|
Restrict delete | ||
| crashes_obj_struck_id_fkey |
|
|
Restrict delete | ||
| crashes_rpt_city_id_fkey |
|
|
Restrict delete | ||
| units_first_harm_evt_inv_id_fkey |
|
|
Restrict delete | ||
| units_veh_body_styl_id_fkey |
|
|
Restrict delete | ||
| units_e_scooter_id_fkey |
|
|
Restrict delete | ||
| units_contrib_factr_1_id_fkey |
|
|
Restrict delete | ||
| units_veh_mod_id_fkey |
|
|
Restrict delete | ||
| units_veh_damage_direction_of_force1_id_fkey |
|
|
Restrict delete | ||
| units_contrib_factr_2_id_fkey |
|
|
Restrict delete | ||
| units_contrib_factr_3_id_fkey |
|
|
Restrict delete | ||
| units_pedalcyclist_action_id_fkey |
|
|
Restrict delete | ||
| units_veh_damage_description1_id_fkey |
|
|
Restrict delete | ||
| units_rpt_autonomous_level_engaged_id_fkey |
|
|
Restrict delete | ||
| units_veh_make_id_fkey |
|
|
Restrict delete | ||
| units_cris_crash_id_fkey |
|
|
Cascade on delete | ||
| units_unit_desc_id_fkey |
|
|
Restrict delete | ||
| units_pedestrian_action_id_fkey |
|
|
Restrict delete | ||
| units_contrib_factr_p1_id_fkey |
|
|
Restrict delete | ||
| units_pbcat_pedalcyclist_id_fkey |
|
|
Restrict delete | ||
| units_veh_damage_severity2_id_fkey |
|
|
Restrict delete | ||
| units_movement_id_fkey |
|
|
Restrict delete | ||
| units_veh_damage_description2_id_fkey |
|
|
Restrict delete | ||
| vz_mode_category_fk |
|
|
Restrict delete | ||
| units_veh_damage_severity1_id_fkey |
|
|
Restrict delete | ||
| units_veh_damage_direction_of_force2_id_fkey |
|
|
Restrict delete | ||
| units_pbcat_pedestrian_id_fkey |
|
|
Restrict delete | ||
| units_veh_trvl_dir_id_fkey |
|
|
Restrict delete | ||
| units_autonomous_unit_id_fkey |
|
|
Restrict delete | ||
| units_crash_pk_fkey |
|
|
Cascade on delete | ||
| units_contrib_factr_p2_id_fkey |
|
|
Restrict delete | ||
| charges_cris_crash_pk_fkey |
|
|
Cascade on delete | ||
| charges_cris_cris_crash_id_fkey |
|
|
Cascade on delete | ||
| charges_cris_person_id_fkey |
|
|
Cascade on delete | ||
| change_log_people_edits_record_id_fkey |
|
|
Cascade on delete | ||
| change_log_people_cris_record_id_fkey |
|
|
Cascade on delete | ||
| change_log_crashes_edits_record_id_fkey |
|
|
Cascade on delete | ||
| change_log_units_cris_record_id_fkey |
|
|
Cascade on delete | ||
| units_cris_veh_damage_direction_of_force2_id_fkey |
|
|
Restrict delete | ||
| units_cris_contrib_factr_p2_id_fkey |
|
|
Restrict delete | ||
| units_cris_contrib_factr_p1_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_damage_description1_id_fkey |
|
|
Restrict delete | ||
| units_cris_pbcat_pedalcyclist_id_fkey |
|
|
Restrict delete | ||
| units_cris_unit_desc_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_damage_direction_of_force1_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_damage_description2_id_fkey |
|
|
Restrict delete | ||
| units_cris_pbcat_pedestrian_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_trvl_dir_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_damage_severity2_id_fkey |
|
|
Restrict delete | ||
| units_cris_contrib_factr_3_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_damage_severity1_id_fkey |
|
|
Restrict delete | ||
| units_cris_contrib_factr_1_id_fkey |
|
|
Restrict delete | ||
| units_cris_cris_crash_id_fkey |
|
|
Cascade on delete | ||
| units_cris_contrib_factr_2_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_make_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_body_styl_id_fkey |
|
|
Restrict delete | ||
| units_cris_rpt_autonomous_level_engaged_id_fkey |
|
|
Restrict delete | ||
| units_cris_pedestrian_action_id_fkey |
|
|
Restrict delete | ||
| units_cris_e_scooter_id_fkey |
|
|
Restrict delete | ||
| units_cris_pedalcyclist_action_id_fkey |
|
|
Restrict delete | ||
| units_cris_veh_mod_id_fkey |
|
|
Restrict delete | ||
| units_cris_first_harm_evt_inv_id_fkey |
|
|
Restrict delete | ||
| units_cris_autonomous_unit_id_fkey |
|
|
Restrict delete | ||
| units_cris_crash_pk_fkey |
|
|
Cascade on delete | ||
| recommendations_partners_recommendation_id_fkey |
|
|
Cascade on delete | ||
| recommendations_partners_partner_id_fkey |
|
|
Cascade on delete | ||
| fk_location_note_location |
|
|
Restrict delete | ||
| change_log_crashes_cris_record_id_fkey |
|
|
Cascade on delete | ||
| notes_crashes_id_fkey |
|
|
Restrict delete | ||
| people_prsn_occpnt_pos_id_fkey |
|
|
Restrict delete | ||
| people_prsn_drg_rslt_id_fkey |
|
|
Restrict delete | ||
| people_prsn_alc_rslt_id_fkey |
|
|
Restrict delete | ||
| people_ems_id_fkey |
|
|
Null on delete | ||
| people_prsn_gndr_id_fkey |
|
|
Restrict delete | ||
| people_drvr_lic_type_id_fkey |
|
|
Restrict delete | ||
| people_prsn_injry_sev_id_fkey |
|
|
Restrict delete | ||
| people_prsn_rest_id_fkey |
|
|
Restrict delete | ||
| people_prsn_type_id_fkey |
|
|
Restrict delete | ||
| people_unit_id_fkey |
|
|
Cascade on delete | ||
| people_prsn_drg_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_prsn_ethnicity_id_fkey |
|
|
Restrict delete | ||
| people_prsn_helmet_id_fkey |
|
|
Restrict delete | ||
| people_prsn_alc_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_drvr_drg_cat_1_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_alc_rslt_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_injry_sev_id_fkey |
|
|
Restrict delete | ||
| people_cris_unit_id_fkey |
|
|
Cascade on delete | ||
| people_cris_prsn_rest_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_drg_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_alc_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_gndr_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_helmet_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_ethnicity_id_fkey |
|
|
Restrict delete | ||
| people_cris_drvr_drg_cat_1_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_drg_rslt_id_fkey |
|
|
Restrict delete | ||
| people_cris_cris_crash_id_fkey |
|
|
Cascade on delete | ||
| people_cris_prsn_type_id_fkey |
|
|
Restrict delete | ||
| people_cris_drvr_lic_type_id_fkey |
|
|
Restrict delete | ||
| people_cris_prsn_occpnt_pos_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_drg_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_alc_spec_type_id_fkey |
|
|
Restrict delete | ||
| people_edits_id_fkey |
|
|
Cascade on delete | ||
| people_edits_prsn_ethnicity_id_fkey |
|
|
Restrict delete | ||
| people_edits_drvr_drg_cat_1_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_occpnt_pos_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_alc_rslt_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_rest_id_fkey |
|
|
Restrict delete | ||
| people_edits_unit_id_fkey |
|
|
Cascade on delete | ||
| people_edits_drvr_lic_type_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_type_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_injry_sev_id_fkey |
|
|
Restrict delete | ||
| people_edits_ems_id_fkey |
|
|
Null on delete | ||
| people_edits_prsn_drg_rslt_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_gndr_id_fkey |
|
|
Restrict delete | ||
| people_edits_prsn_helmet_id_fkey |
|
|
Restrict delete | ||
| units_edits_first_harm_evt_inv_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_body_styl_id_fkey |
|
|
Restrict delete | ||
| units_edits_pbcat_pedestrian_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_damage_severity2_id_fkey |
|
|
Restrict delete | ||
| units_edits_cris_crash_id_fkey |
|
|
Cascade on delete | ||
| units_edits_pedalcyclist_action_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_damage_severity1_id_fkey |
|
|
Restrict delete | ||
| units_edits_autonomous_unit_id_fkey |
|
|
Restrict delete | ||
| units_edits_id_fkey |
|
|
Cascade on delete | ||
| units_edits_e_scooter_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_damage_direction_of_force1_id_fkey |
|
|
Restrict delete | ||
| units_edits_crash_pk_fkey |
|
|
Cascade on delete | ||
| units_edits_veh_damage_direction_of_force2_id_fkey |
|
|
Restrict delete | ||
| units_edits_movement_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_make_id_fkey |
|
|
Restrict delete | ||
| units_edits_contrib_factr_1_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_trvl_dir_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_damage_description1_id_fkey |
|
|
Restrict delete | ||
| units_edits_contrib_factr_p2_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_mod_id_fkey |
|
|
Restrict delete | ||
| units_edits_veh_damage_description2_id_fkey |
|
|
Restrict delete | ||
| units_edits_contrib_factr_p1_id_fkey |
|
|
Restrict delete | ||
| units_edits_unit_desc_id_fkey |
|
|
Restrict delete | ||
| units_edits_contrib_factr_2_id_fkey |
|
|
Restrict delete | ||
| units_edits_contrib_factr_3_id_fkey |
|
|
Restrict delete | ||
| units_edits_pedestrian_action_id_fkey |
|
|
Restrict delete | ||
| units_edits_rpt_autonomous_level_engaged_id_fkey |
|
|
Restrict delete | ||
| units_edits_pbcat_pedalcyclist_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| spatial_ref_sys | spatial_ref_sys_srid_check | (((srid > 0) AND (srid <= 998999))) |
| units_cris | units_cris_unit_desc_id_check | (((unit_desc_id < 177) OR ((created_by <> 'cris'::text) AND (created_by <> 'system'::text)))) |
| units_cris | units_cris_veh_body_styl_id_check | ((veh_body_styl_id < 177)) |
| people_cris | people_cris_prsn_injry_sev_id_check | ((prsn_injry_sev_id < 99)) |