25 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| kk_tutkintoon_johtava_hakukohde_oid_fkey |
|
|
Restrict delete | ||||||
| valinnantilat_valintaesitykset_fk |
|
|
Restrict delete | ||||||
| valinnantilat_hakukohde_oid_fkey |
|
|
Restrict delete | ||||||
| valinnantulokset_valintatapajono_oid_fkey |
|
|
Restrict delete | ||||||
| jonosijat_valintatapajonot |
|
|
Restrict delete | ||||||
| tilat_kuvaukset_valintatapajono_oid_fkey |
|
|
Restrict delete | ||||||
| valintatapajonot_sijoitteluajon_hakukohteet |
|
|
Restrict delete | ||||||
| yhden_paikan_saanto_voimassa_hakukohde_oid_fkey |
|
|
Restrict delete | ||||||
| hakijaryhman_hakemukset_hakijaryhma_oid_fkey |
|
|
Restrict delete | ||||||
| vo_deleted_vastaanotot_fk |
|
|
Restrict delete | ||||||
| vastaanotot_hakukohteet_fk |
|
|
Restrict delete | ||||||
| puuttuvat_tulokset_hakukohde_tarjoaja_fk |
|
|
Restrict delete | ||||||
| sivssnov_sav_valintatapajonot |
|
|
Restrict delete | ||||||
| ehdollisen_hyvaksynnan_ehto_valinnantulokset_hakemus_oid_ensin |
|
|
Restrict delete | ||||||
| puuttuvat_tulokset_tarjoaja_haku_fk |
|
|
Restrict delete | ||||||
| hakijaryhmat_valintatapajonot |
|
|
Restrict delete | ||||||
| hakijaryhmat_sijoitteluajon_hakukohteet |
|
|
Restrict delete | ||||||
| viestit_syy_fkey |
|
|
Restrict delete | ||||||
| koulutuksen_alkamiskausi_hakukohde_oid_fkey |
|
|
Restrict delete | ||||||
| ilmoittautumiset_hakukohteet_fk |
|
|
Restrict delete | ||||||
| roolit_sessio_fkey |
|
|
Cascade on delete | ||||||
| valintaesitykset_hakukohteet_fk |
|
|
Restrict delete | ||||||
| hyvaksytyt_ja_julkaistut_hakutoiveet_hakukohteet_fk |
|
|
Restrict delete | ||||||
| sijoitteluajon_hakukohteet_hakukohde_oid_fkey |
|
|
Restrict delete | ||||||
| sijoitteluajon_hakukohteet_sijoitteluajo_id_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|