Constraints

25 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_payment_enrollment_appointment_id
payment.enrollment_appointment_id
enrollment_appointment.enrollment_appointment_id
Restrict delete
fk_payment_enrollment
payment.enrollment_id
enrollment.enrollment_id
Restrict delete
fk_reservation_exam_event
reservation.exam_event_id
exam_event.exam_event_id
Restrict delete
fk_reservation_person
reservation.person_id
person.person_id
Restrict delete
fk_examiner_municipality_municipality
examiner_municipality.municipality_id
municipality.municipality_id
Restrict delete
fk_examiner_municipality_examiner
examiner_municipality.examiner_id
examiner.examiner_id
Restrict delete
fk_email_email_type
email.email_type
email_type.name
Restrict delete
fk_enrollment_status
enrollment.status
enrollment_status.name
Restrict delete
fk_enrollment_exam_event
enrollment.exam_event_id
exam_event.exam_event_id
Restrict delete
fk_enrollment_person
enrollment.person_id
person.person_id
Restrict delete
fk_enrollment_free_enrollment
enrollment.free_enrollment
free_enrollment.free_enrollment_id
Restrict delete
fk_koski_educations_free_enrollment
koski_educations.free_enrollment_id
free_enrollment.free_enrollment_id
Restrict delete
fk_koski_educations_exam_event
koski_educations.exam_event_id
exam_event.exam_event_id
Restrict delete
fk_exam_event_language
exam_event.language
exam_language.name
Restrict delete
fk_exam_event_level
exam_event.level
exam_level.name
Restrict delete
fk_free_enrollment_person
free_enrollment.person_id
person.person_id
Restrict delete
spring_session_attributes_fk
spring_session_attributes.session_primary_id
spring_session.primary_id
Cascade on delete
fk_examiner_exam_event_language
examiner_exam_event.language
exam_language.name
Restrict delete
fk_examiner_exam_event_examiner_id
examiner_exam_event.examiner_id
examiner.examiner_id
Restrict delete
fk_examiner_exam_event_municipality_id
examiner_exam_event.municipality_id
municipality.municipality_id
Restrict delete
fk_enrollment_appointment_examiner_id
enrollment_appointment.examiner_id
examiner.examiner_id
Restrict delete
fk_enrollment_appointment_examiner_exam_event_id
enrollment_appointment.examiner_exam_event_id
examiner_exam_event.examiner_exam_event_id
Restrict delete
fk_enrollment_appointment_grade_id
enrollment_appointment.grade_id
enrollment_grade.grade_id
Restrict delete
fk_uploaded_file_attachment_free_enrollment
uploaded_file_attachment.free_enrollment_id
free_enrollment.free_enrollment_id
Restrict delete
fk_email_attachment_email
email_attachment.email_id
email.email_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
exam_event ck_exam_event_max_participants ((max_participants >= 0))