50 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| varhaiskasvatuksen_toiminnall_varhaiskasvatuksen_toimipaik_fkey |
|
|
Restrict delete | ||
| organisaatio_sahkoposti_organisaatio_id_fkey |
|
|
Restrict delete | ||
| fkf600ee485425b9f0 |
|
|
Restrict delete | ||
| fkf600ee483ba9203e |
|
|
Restrict delete | ||
| organisaatio_kielet_organisaatio_id_fkey |
|
|
Restrict delete | ||
| fk6f042a037ef4c57a |
|
|
Restrict delete | ||
| fk5a76e4323f4b641b |
|
|
Restrict delete | ||
| organisaatio_lisatieto_lisatietotyyppi_id_fkey |
|
|
Restrict delete | ||
| organisaatio_lisatieto_organisaatio_id_fkey |
|
|
Restrict delete | ||
| queuedemail_osoitteet_haku_and_hakutulos_id_fkey |
|
|
Restrict delete | ||
| queuedemail_queuedemailstatus_id_fkey |
|
|
Restrict delete | ||
| fkf495530635feb64d |
|
|
Restrict delete | ||
| fkf4955306f4108c7c |
|
|
Restrict delete | ||
| fkae4e0c9b3f4b641b |
|
|
Restrict delete | ||
| fkae4e0c9be6d89263 |
|
|
Restrict delete | ||
| fkae4e0c9bd878984e |
|
|
Restrict delete | ||
| spring_session_attributes_fk |
|
|
Cascade on delete | ||
| fk11d1b24d35a11c3b |
|
|
Restrict delete | ||
| rajoite_lisatietotyyppi_id_fkey |
|
|
Restrict delete | ||
| organisaatio_parent_oids_organisaatio_id_fkey |
|
|
Cascade on delete | ||
| fkd68ae7a3f4b641b |
|
|
Restrict delete | ||
| fk4415da7f181d43a9 |
|
|
Restrict delete | ||
| fk4415da7f9419034d |
|
|
Restrict delete | ||
| organisaatio_varhaiskasvatuksen_toimipaikka_tiedot_id_fkey |
|
|
Restrict delete | ||
| fk4415da7fc91e743b |
|
|
Restrict delete | ||
| fk4415da7f181d43a9 |
|
|
Restrict delete | ||
| fkf5f2b32035a11c3b |
|
|
Restrict delete | ||
| fk3f3c38979419034d |
|
|
Restrict delete | ||
| organisaatio_koulutuslupa_organisaatio_id_fkey |
|
|
Restrict delete | ||
| organisaatio_koulutuslupa_koulutuskoodiarvo_fkey |
|
|
Restrict delete | ||
| organisaatio_muut_oppilaitostyypit_organisaatio_id_fkey |
|
|
Restrict delete | ||
| fkba6a319e3f4b641b |
|
|
Restrict delete | ||
| fk56c654673f4b641b |
|
|
Restrict delete | ||
| fk0f14b15f3f4b641b |
|
|
Restrict delete | ||
| fkdcabfe80f46f0057 |
|
|
Restrict delete | ||
| fkdcabfe80f4108c7c |
|
|
Restrict delete | ||
| fk4nfmp4pb08x2vntptw88pgcu7 |
|
|
Restrict delete | ||
| fk1c883eeef27eb12 |
|
|
Restrict delete | ||
| fk1c883eee93d0549b |
|
|
Restrict delete | ||
| fk1c883eeef3403622 |
|
|
Restrict delete | ||
| fk4250636be5979fae |
|
|
Restrict delete | ||
| fkd3eb79572ae75708 |
|
|
Restrict delete | ||
| fkd3eb7957e5979fae |
|
|
Restrict delete | ||
| varhaiskasvatuksen_toimintamu_varhaiskasvatuksen_toimipaik_fkey |
|
|
Restrict delete | ||
| varhaiskasvatuksen_kielipaino_varhaiskasvatuksen_toimipaik_fkey |
|
|
Restrict delete | ||
| maakuntakuntarelation_kuntauri_fkey |
|
|
Restrict delete | ||
| maakuntakuntarelation_maakuntauri_fkey |
|
|
Restrict delete | ||
| fkf7d456513f4b641b |
|
|
Restrict delete | ||
| fkae6e4e8e35a11c3b |
|
|
Restrict delete | ||
| ytjvirhe_ytjpaivitys |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| queuedemail | recipients_required | ((recipients <> '{}'::text[])) |
| queuedemail | sent_at_requires_status_sent | ((((queuedemailstatus_id = 'SENT'::text) AND (sent_at IS NOT NULL)) OR (queuedemailstatus_id <> 'SENT'::text))) |
| queuedemail | sent_has_to_have_lahetystunniste | ((((queuedemailstatus_id = 'SENT'::text) AND (lahetystunniste IS NOT NULL)) OR (queuedemailstatus_id <> 'SENT'::text))) |