Constraints

29 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
period_length_history_original_period_length_id_fkey
period_length_history.original_period_length_id
period_length.id
Restrict delete
charge_history_original_charge_id_fkey
charge_history.original_charge_id
charge.id
Restrict delete
recall_type_id_fk
recall.recall_type_id
recall_type.id
Restrict delete
uploaded_document_appearance_id_fkey
uploaded_document.appearance_id
court_appearance.id
Restrict delete
sentence_sentence_type_id_fkey
sentence.sentence_type_id
sentence_type.id
Restrict delete
sentence_superseding_sentence_id_fkey
sentence.superseding_sentence_id
sentence.id
Restrict delete
sentence_charge_id_fkey
sentence.charge_id
charge.id
Restrict delete
sentence_consecutive_to_id_fkey
sentence.consecutive_to_id
sentence.id
Restrict delete
court_appearance_history_original_appearance_id_fkey
court_appearance_history.original_appearance_id
court_appearance.id
Restrict delete
sentence_history_original_sentence_id_fkey
sentence_history.original_sentence_id
sentence.id
Restrict delete
fk_merged_to_case_id
court_case.merged_to_case_id
court_case.id
Restrict delete
latest_court_appearance_fk
court_case.latest_court_appearance_id
court_appearance.id
Restrict delete
appearance_charge_appearance_id_fkey
appearance_charge.appearance_id
court_appearance.id
Restrict delete
appearance_charge_charge_id_fkey
appearance_charge.charge_id
charge.id
Restrict delete
court_appearance_appearance_outcome_id_fkey
court_appearance.appearance_outcome_id
appearance_outcome.id
Restrict delete
court_appearance_court_case_id_fkey
court_appearance.court_case_id
court_case.id
Restrict delete
fk_recall_sentence_history_to_recall_history
recall_sentence_history.recall_history_id
recall_history.id
Restrict delete
court_case_history_original_court_case_id_fkey
court_case_history.original_court_case_id
court_case.id
Restrict delete
charge_superseding_charge_id_fkey
charge.superseding_charge_id
charge.id
Restrict delete
charge_charge_outcome_id_fkey
charge.charge_outcome_id
charge_outcome.id
Restrict delete
charge_merged_from_case_id_fkey
charge.merged_from_case_id
court_case.id
Restrict delete
next_court_appearance_future_skeleton_appearance_id_fkey
next_court_appearance.future_skeleton_appearance_id
court_appearance.id
Restrict delete
next_court_appearance_appearance_type_id_fkey
next_court_appearance.appearance_type_id
appearance_type.id
Restrict delete
period_length_appearance_id_fkey
period_length.appearance_id
court_appearance.id
Restrict delete
period_length_sentence_id_fkey
period_length.sentence_id
sentence.id
Restrict delete
fk_sentence_type_uuid
legacy_sentence_types.sentence_type_uuid
sentence_type.sentence_type_uuid
Restrict delete
legacy_sentence_types_recall_type_id_fkey
legacy_sentence_types.recall_type_id
recall_type.id
Restrict delete
fk_recall_sentence_to_recall
recall_sentence.recall_id
recall.id
Restrict delete
fk_recall_sentence_to_sentence
recall_sentence.sentence_id
sentence.id
Restrict delete

Check Constraints

Table Constraint Name Constraint