Constraints

118 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
odycrim_services_case_number_fkey
odycrim_services.case_number
odycrim.case_number
Cascade on delete
odycivil_judgment_comments_case_number_fkey
odycivil_judgment_comments.case_number
odycivil.case_number
Cascade on delete
dscr_bail_events_case_number_fkey
dscr_bail_events.case_number
dscr.case_number
Cascade on delete
odycrim_attorneys_case_number_fkey
odycrim_attorneys.case_number
odycrim.case_number
Cascade on delete
odycrim_attorneys_defendant_id_fkey
odycrim_attorneys.defendant_id
odycrim_defendants.id
Restrict delete
odycrim_attorneys_party_id_fkey
odycrim_attorneys.party_id
odycrim_involved_parties.id
Restrict delete
odycivil_involved_parties_case_number_fkey
odycivil_involved_parties.case_number
odycivil.case_number
Cascade on delete
scrapes_case_number_fkey
scrapes.case_number
cases.case_number
Cascade on delete
scrapes_s3_version_id_fkey
scrapes.s3_version_id
scrape_versions.s3_version_id
Cascade on delete
odycivil_cause_remedies_cause_id_fkey
odycivil_cause_remedies.cause_id
odycivil_causes.id
Restrict delete
odycivil_cause_remedies_case_number_fkey
odycivil_cause_remedies.case_number
odycivil.case_number
Cascade on delete
odycivil_aliases_party_id_fkey
odycivil_aliases.party_id
odycivil_involved_parties.id
Restrict delete
odycivil_aliases_case_number_fkey
odycivil_aliases.case_number
odycivil.case_number
Cascade on delete
odycivil_aliases_defendant_id_fkey
odycivil_aliases.defendant_id
odycivil_defendants.id
Restrict delete
odytraf_involved_parties_case_number_fkey
odytraf_involved_parties.case_number
odytraf.case_number
Cascade on delete
dsk8_related_persons_case_number_fkey
dsk8_related_persons.case_number
dsk8.case_number
Cascade on delete
dscr_defendants_case_number_fkey
dscr_defendants.case_number
dscr.case_number
Cascade on delete
odytraf_aliases_defendant_id_fkey
odytraf_aliases.defendant_id
odytraf_defendants.id
Restrict delete
odytraf_aliases_party_id_fkey
odytraf_aliases.party_id
odytraf_involved_parties.id
Restrict delete
odytraf_aliases_case_number_fkey
odytraf_aliases.case_number
odytraf.case_number
Cascade on delete
odycrim_charges_case_number_fkey
odycrim_charges.case_number
odycrim.case_number
Cascade on delete
odytraf_warrants_case_number_fkey
odytraf_warrants.case_number
odytraf.case_number
Cascade on delete
dsk8_defendant_aliases_case_number_fkey
dsk8_defendant_aliases.case_number
dsk8.case_number
Cascade on delete
cc_party_addresses_related_person_id_fkey
cc_party_addresses.related_person_id
cc_related_persons.id
Restrict delete
cc_party_addresses_plaintiff_id_fkey
cc_party_addresses.plaintiff_id
cc_plaintiffs.id
Restrict delete
cc_party_addresses_defendant_id_fkey
cc_party_addresses.defendant_id
cc_defendants.id
Restrict delete
cc_party_addresses_case_number_fkey
cc_party_addresses.case_number
cc.case_number
Cascade on delete
odycivil_dispositions_case_number_fkey
odycivil_dispositions.case_number
odycivil.case_number
Cascade on delete
odytraf_reference_numbers_case_number_fkey
odytraf_reference_numbers.case_number
odytraf.case_number
Cascade on delete
dscr_defendant_aliases_case_number_fkey
dscr_defendant_aliases.case_number
dscr.case_number
Cascade on delete
cc_party_alias_case_number_fkey
cc_party_alias.case_number
cc.case_number
Cascade on delete
cc_party_alias_plaintiff_id_fkey
cc_party_alias.plaintiff_id
cc_plaintiffs.id
Restrict delete
cc_party_alias_related_person_id_fkey
cc_party_alias.related_person_id
cc_related_persons.id
Restrict delete
cc_party_alias_defendant_id_fkey
cc_party_alias.defendant_id
cc_defendants.id
Restrict delete
cc_documents_case_number_fkey
cc_documents.case_number
cc.case_number
Cascade on delete
odycrim_bond_settings_case_number_fkey
odycrim_bond_settings.case_number
odycrim.case_number
Cascade on delete
dscivil_trials_case_number_fkey
dscivil_trials.case_number
dscivil.case_number
Cascade on delete
odycivil_defendants_case_number_fkey
odycivil_defendants.case_number
odycivil.case_number
Cascade on delete
odycivil_reference_numbers_case_number_fkey
odycivil_reference_numbers.case_number
odycivil.case_number
Cascade on delete
dscr_events_case_number_fkey
dscr_events.case_number
dscr.case_number
Cascade on delete
odycivil_court_schedule_case_number_fkey
odycivil_court_schedule.case_number
odycivil.case_number
Cascade on delete
cc_judgments_case_number_fkey
cc_judgments.case_number
cc.case_number
Cascade on delete
dscr_related_persons_case_number_fkey
dscr_related_persons.case_number
dscr.case_number
Cascade on delete
odytraf_court_schedule_case_number_fkey
odytraf_court_schedule.case_number
odytraf.case_number
Cascade on delete
dscr_case_number_fkey
dscr.case_number
cases.case_number
Cascade on delete
odycivil_services_case_number_fkey
odycivil_services.case_number
odycivil.case_number
Cascade on delete
cc_judgments_against_case_number_fkey
cc_judgments_against.case_number
cc.case_number
Cascade on delete
cc_judgments_against_judgment_id_fkey
cc_judgments_against.judgment_id
cc_judgments.id
Restrict delete
cc_district_case_numbers_case_number_fkey
cc_district_case_numbers.case_number
cc.case_number
Cascade on delete
odycivil_documents_case_number_fkey
odycivil_documents.case_number
odycivil.case_number
Cascade on delete
odycrim_reference_numbers_case_number_fkey
odycrim_reference_numbers.case_number
odycrim.case_number
Cascade on delete
dscivil_judgments_complaint_id_fkey
dscivil_judgments.complaint_id
dscivil_complaints.id
Restrict delete
dscivil_judgments_case_number_fkey
dscivil_judgments.case_number
dscivil.case_number
Cascade on delete
odycrim_documents_case_number_fkey
odycrim_documents.case_number
odycrim.case_number
Cascade on delete
dscivil_hearings_complaint_id_fkey
dscivil_hearings.complaint_id
dscivil_complaints.id
Restrict delete
dscivil_hearings_case_number_fkey
dscivil_hearings.case_number
dscivil.case_number
Cascade on delete
cc_judgment_modifications_case_number_fkey
cc_judgment_modifications.case_number
cc.case_number
Cascade on delete
cc_judgment_modifications_judgment_id_fkey
cc_judgment_modifications.judgment_id
cc_judgments.id
Restrict delete
dscivil_case_number_fkey
dscivil.case_number
cases.case_number
Cascade on delete
dscivil_events_case_number_fkey
dscivil_events.case_number
dscivil.case_number
Cascade on delete
odycivil_attorneys_case_number_fkey
odycivil_attorneys.case_number
odycivil.case_number
Cascade on delete
odycivil_attorneys_party_id_fkey
odycivil_attorneys.party_id
odycivil_involved_parties.id
Restrict delete
odycivil_attorneys_defendant_id_fkey
odycivil_attorneys.defendant_id
odycivil_defendants.id
Restrict delete
cc_judgments_in_favor_judgment_id_fkey
cc_judgments_in_favor.judgment_id
cc_judgments.id
Restrict delete
cc_judgments_in_favor_case_number_fkey
cc_judgments_in_favor.case_number
cc.case_number
Cascade on delete
dsk8_bail_and_bond_case_number_fkey
dsk8_bail_and_bond.case_number
dsk8.case_number
Cascade on delete
dscr_trials_case_number_fkey
dscr_trials.case_number
dscr.case_number
Cascade on delete
dsk8_case_number_fkey
dsk8.case_number
cases.case_number
Cascade on delete
odycrim_involved_parties_case_number_fkey
odycrim_involved_parties.case_number
odycrim.case_number
Cascade on delete
odytraf_defendants_case_number_fkey
odytraf_defendants.case_number
odytraf.case_number
Cascade on delete
odycivil_bond_settings_case_number_fkey
odycivil_bond_settings.case_number
odycivil.case_number
Cascade on delete
odytraf_bond_settings_case_number_fkey
odytraf_bond_settings.case_number
odytraf.case_number
Cascade on delete
dsk8_charges_case_number_fkey
dsk8_charges.case_number
dsk8.case_number
Cascade on delete
odycivil_judgments_case_number_fkey
odycivil_judgments.case_number
odycivil.case_number
Cascade on delete
cc_related_persons_case_number_fkey
cc_related_persons.case_number
cc.case_number
Cascade on delete
cc_plaintiffs_case_number_fkey
cc_plaintiffs.case_number
cc.case_number
Cascade on delete
cc_attorneys_plaintiff_id_fkey
cc_attorneys.plaintiff_id
cc_plaintiffs.id
Restrict delete
cc_attorneys_related_person_id_fkey
cc_attorneys.related_person_id
cc_related_persons.id
Restrict delete
cc_attorneys_case_number_fkey
cc_attorneys.case_number
cc.case_number
Cascade on delete
cc_attorneys_defendant_id_fkey
cc_attorneys.defendant_id
cc_defendants.id
Restrict delete
odycrim_court_schedule_case_number_fkey
odycrim_court_schedule.case_number
odycrim.case_number
Cascade on delete
odytraf_documents_case_number_fkey
odytraf_documents.case_number
odytraf.case_number
Cascade on delete
odycrim_probation_case_number_fkey
odycrim_probation.case_number
odycrim.case_number
Cascade on delete
odycrim_restitutions_case_number_fkey
odycrim_restitutions.case_number
odycrim.case_number
Cascade on delete
odytraf_bail_bonds_case_number_fkey
odytraf_bail_bonds.case_number
odytraf.case_number
Cascade on delete
odycivil_causes_case_number_fkey
odycivil_causes.case_number
odycivil.case_number
Cascade on delete
cc_defendants_case_number_fkey
cc_defendants.case_number
cc.case_number
Cascade on delete
dscivil_related_persons_complaint_id_fkey
dscivil_related_persons.complaint_id
dscivil_complaints.id
Restrict delete
dscivil_related_persons_case_number_fkey
dscivil_related_persons.case_number
dscivil.case_number
Cascade on delete
dscivil_complaints_case_number_fkey
dscivil_complaints.case_number
dscivil.case_number
Cascade on delete
odycivil_judgment_statuses_judgment_id_fkey
odycivil_judgment_statuses.judgment_id
odycivil_judgments.id
Restrict delete
odycivil_judgment_statuses_case_number_fkey
odycivil_judgment_statuses.case_number
odycivil.case_number
Cascade on delete
odytraf_charges_case_number_fkey
odytraf_charges.case_number
odytraf.case_number
Cascade on delete
odycrim_aliases_case_number_fkey
odycrim_aliases.case_number
odycrim.case_number
Cascade on delete
odycrim_aliases_defendant_id_fkey
odycrim_aliases.defendant_id
odycrim_defendants.id
Restrict delete
odycrim_aliases_party_id_fkey
odycrim_aliases.party_id
odycrim_involved_parties.id
Restrict delete
cc_case_number_fkey
cc.case_number
cases.case_number
Cascade on delete
odytraf_case_number_fkey
odytraf.case_number
cases.case_number
Cascade on delete
odytraf_services_case_number_fkey
odytraf_services.case_number
odytraf.case_number
Cascade on delete
odycrim_bail_bonds_case_number_fkey
odycrim_bail_bonds.case_number
odycrim.case_number
Cascade on delete
odytraf_attorneys_case_number_fkey
odytraf_attorneys.case_number
odytraf.case_number
Cascade on delete
odytraf_attorneys_defendant_id_fkey
odytraf_attorneys.defendant_id
odytraf_defendants.id
Restrict delete
odytraf_attorneys_party_id_fkey
odytraf_attorneys.party_id
odytraf_involved_parties.id
Restrict delete
odycrim_warrants_case_number_fkey
odycrim_warrants.case_number
odycrim.case_number
Cascade on delete
dsk8_trials_case_number_fkey
dsk8_trials.case_number
dsk8.case_number
Cascade on delete
odycrim_case_number_fkey
odycrim.case_number
cases.case_number
Cascade on delete
odycrim_defendants_case_number_fkey
odycrim_defendants.case_number
odycrim.case_number
Cascade on delete
dsk8_events_case_number_fkey
dsk8_events.case_number
dsk8.case_number
Cascade on delete
dsk8_bondsman_bail_and_bond_id_fkey
dsk8_bondsman.bail_and_bond_id
dsk8_bail_and_bond.id
Restrict delete
dsk8_bondsman_case_number_fkey
dsk8_bondsman.case_number
dsk8.case_number
Cascade on delete
odycivil_case_number_fkey
odycivil.case_number
cases.case_number
Cascade on delete
scrape_versions_case_number_fkey
scrape_versions.case_number
cases.case_number
Cascade on delete
cc_support_orders_case_number_fkey
cc_support_orders.case_number
cc.case_number
Cascade on delete
cc_court_schedule_case_number_fkey
cc_court_schedule.case_number
cc.case_number
Cascade on delete
odycivil_warrants_case_number_fkey
odycivil_warrants.case_number
odycivil.case_number
Cascade on delete
dsk8_defendants_case_number_fkey
dsk8_defendants.case_number
dsk8.case_number
Cascade on delete
dscr_charges_case_number_fkey
dscr_charges.case_number
dscr.case_number
Cascade on delete
odycivil_bail_bonds_case_number_fkey
odycivil_bail_bonds.case_number
odycivil.case_number
Cascade on delete

Check Constraints

Table Constraint Name Constraint