Constraints

3 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
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 ((((lahde = 'KOSKI'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL)) OR ((lahde = 'YTR'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL)) OR ((lahde = 'VIRTA'::lahde) AND (data_json IS NULL) AND (data_xml IS NOT NULL)) OR ((lahde = 'VIRKAILIJA'::lahde) AND (data_json IS NOT NULL) AND (data_xml IS NULL))))
versiot versiot_check1 ((((use_versio_tunniste IS NOT NULL) AND (data_parseroitu IS NULL)) OR ((use_versio_tunniste IS NULL) AND (data_parseroitu IS NOT NULL))))