Constraints

7 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
fk_qualification_reminder_qualification
qualification_reminder.qualification_id
qualification.qualification_id
Restrict delete
fk_qualification_reminder_email
qualification_reminder.email_id
email.email_id
Restrict delete
fk_qualification_interpreter
qualification.interpreter_id
interpreter.interpreter_id
Restrict delete
fk_qualification_examination_type
qualification.examination_type
qualification_examination_type.name
Restrict delete
fk_qualification_meeting_date
qualification.meeting_date_id
meeting_date.meeting_date_id
Restrict delete
fk_email_email_type
email.email_type
email_type.name
Restrict delete
fk_region_interpreter
region.interpreter_id
interpreter.interpreter_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
qualification ck_qualification_begin_date_end_date ((begin_date < end_date))
qualification ck_qualification_from_lang (((from_lang)::text = 'FI'::text))
qualification ck_qualification_from_lang_to_lang (((from_lang)::text <> (to_lang)::text))