31 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| period_length_history_original_period_length_id_fkey |
|
|
Restrict delete | ||
| appearance_subtype_appearance_type_fk |
|
|
Restrict delete | ||
| charge_history_original_charge_id_fkey |
|
|
Restrict delete | ||
| recall_type_id_fk |
|
|
Restrict delete | ||
| uploaded_document_appearance_id_fkey |
|
|
Restrict delete | ||
| sentence_sentence_type_id_fkey |
|
|
Restrict delete | ||
| sentence_superseding_sentence_id_fkey |
|
|
Restrict delete | ||
| sentence_charge_id_fkey |
|
|
Restrict delete | ||
| sentence_consecutive_to_id_fkey |
|
|
Restrict delete | ||
| court_appearance_history_original_appearance_id_fkey |
|
|
Restrict delete | ||
| sentence_history_original_sentence_id_fkey |
|
|
Restrict delete | ||
| fk_merged_to_case_id |
|
|
Restrict delete | ||
| latest_court_appearance_fk |
|
|
Restrict delete | ||
| appearance_charge_appearance_id_fkey |
|
|
Restrict delete | ||
| appearance_charge_charge_id_fkey |
|
|
Restrict delete | ||
| court_appearance_appearance_outcome_id_fkey |
|
|
Restrict delete | ||
| court_appearance_court_case_id_fkey |
|
|
Restrict delete | ||
| fk_recall_sentence_history_to_recall_history |
|
|
Restrict delete | ||
| court_case_history_original_court_case_id_fkey |
|
|
Restrict delete | ||
| charge_superseding_charge_id_fkey |
|
|
Restrict delete | ||
| charge_charge_outcome_id_fkey |
|
|
Restrict delete | ||
| charge_merged_from_case_id_fkey |
|
|
Restrict delete | ||
| next_court_appearance_future_skeleton_appearance_id_fkey |
|
|
Restrict delete | ||
| next_appearance_subtype_fk |
|
|
Restrict delete | ||
| next_court_appearance_appearance_type_id_fkey |
|
|
Restrict delete | ||
| period_length_appearance_id_fkey |
|
|
Restrict delete | ||
| period_length_sentence_id_fkey |
|
|
Restrict delete | ||
| fk_sentence_type_uuid |
|
|
Restrict delete | ||
| legacy_sentence_types_recall_type_id_fkey |
|
|
Restrict delete | ||
| fk_recall_sentence_to_recall |
|
|
Restrict delete | ||
| fk_recall_sentence_to_sentence |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|