Constraints

15 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

harkinnanvaraisuus_process_application_id_fkey

harkinnanvaraisuus_process.application_id

applications.id

Cascade on delete

multi_answer_values_application_id_fkey

multi_answer_values.application_id

multi_answer_values.key

multi_answers.application_id

multi_answers.key

Cascade on delete

information_requests_virkailija_oid_fkey

information_requests.virkailija_oid

Restrict delete

multi_answers_application_id_fkey

multi_answers.application_id

applications.id

Cascade on delete

group_answer_values_application_id_fkey

group_answer_values.application_id

group_answer_values.key

group_answer_values.group_idx

group_answer_groups.application_id

group_answer_groups.key

group_answer_groups.group_idx

Cascade on delete

group_answers_application_id_fkey

group_answers.application_id

applications.id

Cascade on delete

virkailija_credentials_oid_fkey

virkailija_credentials.oid

Restrict delete

answers_application_id_fkey

answers.application_id

applications.id

Cascade on delete

group_answer_groups_application_id_fkey

group_answer_groups.application_id

group_answer_groups.key

group_answers.application_id

group_answers.key

Cascade on delete

virkailija_rewrite_secrets_virkailija_oid_fkey

virkailija_rewrite_secrets.virkailija_oid

Restrict delete

virkailija_update_secrets_virkailija_oid_fkey

virkailija_update_secrets.virkailija_oid

Restrict delete

email_templates_virkailija_oid_fkey

email_templates.virkailija_oid

Restrict delete

application_events_virkailija_oid_fkey

application_events.virkailija_oid

Restrict delete

virkailija_create_secrets_virkailija_oid_fkey

virkailija_create_secrets.virkailija_oid

Restrict delete

application_review_notes_virkailija_oid_fkey

application_review_notes.virkailija_oid

Restrict delete

Check Constraints

Table	Constraint Name	Constraint