Constraints

5 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
opiskeluoikeudet_versio_tunniste_fkey
opiskeluoikeudet.versio_tunniste
versiot.tunniste
Restrict delete
cas_client_session_fk
cas_client_session.session_id
spring_session.session_id
Cascade on delete
spring_session_attributes_fk
spring_session_attributes.session_primary_id
spring_session.primary_id
Cascade on delete
versiot_oppijanumero_fkey
versiot.oppijanumero
oppijat.oppijanumero
Restrict delete
versiot_use_versio_tunniste_fkey
versiot.use_versio_tunniste
versiot.tunniste
Restrict delete

Check Constraints

Table Constraint Name Constraint
versiot versiot_check (((((suoritusjoukko)::text = 'VIRTA'::text) AND (data_json IS NULL) AND (data_xml IS NOT NULL)) OR ((data_json IS NOT NULL) AND (data_xml IS NULL))))