39 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| fkqxc9bei86pmc2oduhmsfn1h4t |
|
|
Restrict delete | ||
| fkd8005c5b992bc1c2 |
|
|
Restrict delete | ||
| fkd8005c5b620670b2 |
|
|
Restrict delete | ||
| fk_henkilo_hetu_henkilo |
|
|
Restrict delete | ||
| henkilo_huoltaja_suhde_aud_lapsi_id_fkey |
|
|
Restrict delete | ||
| henkilo_huoltaja_suhde_aud_huoltaja_id_fkey |
|
|
Restrict delete | ||
| fkd2b4a4cf620670b2 |
|
|
Restrict delete | ||
| fkd2b4b4cf46057a12 |
|
|
Restrict delete | ||
| fk_kotikunta_historia_henkilo_id |
|
|
Restrict delete | ||
| queuedemail_queuedemailstatus_id_fkey |
|
|
Restrict delete | ||
| fk_yksilointivirhe_henkilo |
|
|
Restrict delete | ||
| fk_turvakielto_kotikunta_historia_henkilo_id |
|
|
Restrict delete | ||
| fkd2b8f4cf620670b2 |
|
|
Restrict delete | ||
| spring_session_attributes_fk |
|
|
Cascade on delete | ||
| fk_turvakielto_kotikunta_henkilo_id |
|
|
Restrict delete | ||
| fk41c7a27769456177 |
|
|
Restrict delete | ||
| fk31a7f27569a56372 |
|
|
Restrict delete | ||
| fk_henkilo_passinumero |
|
|
Restrict delete | ||
| fk187d426e620670b2 |
|
|
Restrict delete | ||
| fk15eutxmeqyb0v9v43yye2blxj |
|
|
Restrict delete | ||
| fk51lq458r1exfr6c6tswgk8n3e |
|
|
Restrict delete | ||
| fk41b7e277620670b2 |
|
|
Restrict delete | ||
| fk41b7e27769456172 |
|
|
Restrict delete | ||
| fk_henkilo_organisaatio_henkilo |
|
|
Restrict delete | ||
| fk_henkilo_organisaatio_organisaatio |
|
|
Restrict delete | ||
| fk_tuonti_rivi_henkilo |
|
|
Restrict delete | ||
| fk_tuonti_rivi_tuonti |
|
|
Restrict delete | ||
| fk1lnfibi79dla4p3yr6nqr2uu1 |
|
|
Restrict delete | ||
| fk_tuonti_organisaatio_organisaatio |
|
|
Restrict delete | ||
| fk_tuonti_organisaatio_tuonti |
|
|
Restrict delete | ||
| fk36b34d7566a263b2 |
|
|
Restrict delete | ||
| fka02a62f3dc0430b7 |
|
|
Restrict delete | ||
| henkilo_huoltaja_suhde_huoltaja_id_fkey |
|
|
Restrict delete | ||
| henkilo_huoltaja_suhde_lapsi_id_fkey |
|
|
Restrict delete | ||
| fk_tuonti_tuonti_data |
|
|
Restrict delete | ||
| fkdv42xjyagek2570e9ftgfx1wp |
|
|
Restrict delete | ||
| fk_externalid_henkilo |
|
|
Restrict delete | ||
| fk24c7f3776ba553a1 |
|
|
Restrict delete | ||
| fk3021ddf2565e98a4 |
|
|
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))) |