17 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| harkinnanvaraisuus_process_application_id_fkey |
|
|
Cascade on delete | ||||||
| kk_application_payment_permit_checks_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| kk_application_payment_permit_checks_application_key_fkey |
|
|
Restrict delete | ||||||
| multi_answer_values_application_id_fkey |
|
|
Cascade on delete | ||||||
| information_requests_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| multi_answers_application_id_fkey |
|
|
Cascade on delete | ||||||
| group_answer_values_application_id_fkey |
|
|
Cascade on delete | ||||||
| group_answers_application_id_fkey |
|
|
Cascade on delete | ||||||
| virkailija_credentials_oid_fkey |
|
|
Restrict delete | ||||||
| answers_application_id_fkey |
|
|
Cascade on delete | ||||||
| group_answer_groups_application_id_fkey |
|
|
Cascade on delete | ||||||
| virkailija_rewrite_secrets_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| virkailija_update_secrets_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| email_templates_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| application_events_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| virkailija_create_secrets_virkailija_oid_fkey |
|
|
Restrict delete | ||||||
| application_review_notes_virkailija_oid_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| kk_application_payment_permit_checks | kk_application_payment_permit_ch_payment_obligation_basis_check | (payment_obligation_basis = ANY (ARRAY['not-obligated'::text, 'obligated-own-studies'::text, 'obligated-family-member-studies'::text, 'obligated-other'::text])) |