5 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| kayttaja_rekisterointi_fkey |
|
|
Restrict delete | ||
| organisaatio_rekisterointi_id_fkey |
|
|
Cascade on delete | ||
| yhteystiedot_rekisterointi_id_fkey |
|
|
Cascade on delete | ||
| spring_session_attributes_fk |
|
|
Cascade on delete | ||
| paatos_rekisterointi_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| rekisterointi | valid_tila | ((((tila)::text = 'KASITTELYSSA'::text) OR ((tila)::text = 'HYVAKSYTTY'::text) OR ((tila)::text = 'HYLATTY'::text))) |
| rekisterointi | varda_constraint | ( CASE tyyppi WHEN 'varda'::text THEN ((toimintamuoto IS NOT NULL) AND (kunnat IS NOT NULL)) ELSE true END) |