Constraints

39 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
exam_date_language_level_code_fkey2
exam_date_language.level_code
exam_level.code
Restrict delete
exam_date_language_language_code_fkey
exam_date_language.language_code
language.code
Restrict delete
exam_date_language_level_code_fkey3
exam_date_language.level_code
exam_level.code
Restrict delete
exam_date_language_level_code_fkey
exam_date_language.level_code
exam_level.code
Restrict delete
exam_date_language_exam_date_id_fkey
exam_date_language.exam_date_id
exam_date.id
Restrict delete
exam_date_language_level_code_fkey1
exam_date_language.level_code
exam_level.code
Restrict delete
payment_registration_id_fkey
payment.registration_id
registration.id
Restrict delete
contact_organizer_id_fkey
contact.organizer_id
organizer.id
Restrict delete
evaluation_order_evaluation_id_fkey
evaluation_order.evaluation_id
evaluation.id
Restrict delete
login_link_exam_session_id_fkey
login_link.exam_session_id
exam_session.id
Restrict delete
login_link_participant_id_fkey
login_link.participant_id
participant.id
Restrict delete
login_link_registration_id_fkey
login_link.registration_id
registration.id
Restrict delete
quarantine_language_code_fkey
quarantine.language_code
language.code
Restrict delete
payment_config_organizer_id_fkey
payment_config.organizer_id
organizer.id
Restrict delete
evaluation_payment_evaluation_order_id_fkey
evaluation_payment.evaluation_order_id
evaluation_order.id
Restrict delete
registration_exam_session_id_fkey
registration.exam_session_id
exam_session.id
Restrict delete
registration_original_exam_session_id_fkey
registration.original_exam_session_id
exam_session.id
Restrict delete
registration_participant_id_fkey
registration.participant_id
participant.id
Restrict delete
evaluation_order_subtest_evaluation_order_id_fkey
evaluation_order_subtest.evaluation_order_id
evaluation_order.id
Cascade on delete
evaluation_order_subtest_subtest_fkey
evaluation_order_subtest.subtest
subtest.code
Restrict delete
evaluation_payment_new_evaluation_order_id_fkey
evaluation_payment_new.evaluation_order_id
evaluation_order.id
Restrict delete
exam_language_level_code_fkey
exam_language.level_code
exam_level.code
Restrict delete
exam_language_organizer_id_fkey
exam_language.organizer_id
organizer.id
Restrict delete
exam_language_language_code_fkey
exam_language.language_code
language.code
Restrict delete
quarantine_review_registration_id_fkey
quarantine_review.registration_id
registration.id
Restrict delete
quarantine_review_quarantine_id_fkey
quarantine_review.quarantine_id
quarantine.id
Restrict delete
exam_session_contact_contact_id_fkey
exam_session_contact.contact_id
contact.id
Cascade on delete
exam_session_contact_exam_session_id_fkey
exam_session_contact.exam_session_id
exam_session.id
Cascade on delete
evaluation_exam_date_language_id_fkey
evaluation.exam_date_language_id
exam_date_language.id
Restrict delete
evaluation_exam_date_id_fkey
evaluation.exam_date_id
exam_date.id
Restrict delete
exam_session_location_exam_session_id_fkey
exam_session_location.exam_session_id
exam_session.id
Cascade on delete
exam_session_language_code_fkey
exam_session.language_code
language.code
Restrict delete
exam_session_level_code_fkey
exam_session.level_code
exam_level.code
Restrict delete
exam_session_organizer_id_fkey
exam_session.organizer_id
organizer.id
Restrict delete
exam_session_exam_date_id_fkey
exam_session.exam_date_id
exam_date.id
Restrict delete
exam_session_queue_exam_session_id_fkey
exam_session_queue.exam_session_id
exam_session.id
Cascade on delete
participant_onr_participant_id_fkey
participant_onr.participant_id
participant.id
Restrict delete
participant_sync_status_exam_session_id_fkey
participant_sync_status.exam_session_id
exam_session.id
Restrict delete
exam_payment_new_registration_id_fkey
exam_payment_new.registration_id
registration.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
quarantine ck_quarantine_start_date_end_date ((start_date < end_date))