3 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fk_case_note_amendment_case_note_id |
|
|
Restrict delete | ||
| fk_case_note_sub_type_id |
|
|
Restrict delete | ||
| case_note_sub_type_type_code |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| case_note_amendment | check_system | ((system)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[])) |
| case_note_deleted | check_cause | ((cause)::text = ANY ((ARRAY['DELETE'::character varying, 'UPDATE'::character varying, 'MERGE'::character varying, 'MOVE'::character varying])::text[])) |
| case_note_deleted | check_source | ((system)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[])) |
| case_note | check_system | ((system)::text = ANY ((ARRAY['DPS'::character varying, 'NOMIS'::character varying])::text[])) |