Constraints

10 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_email_email_type

email.email_type

email_type.name

Restrict delete

fk_authorisation_translator

authorisation.translator_id

translator.translator_id

Restrict delete

fk_authorisation_authorisation_basis

authorisation.basis

authorisation_basis.name

Restrict delete

fk_authorisation_meeting_date

authorisation.meeting_date_id

meeting_date.meeting_date_id

Restrict delete

fk_authorisation_examination_date

authorisation.examination_date_id

examination_date.examination_date_id

Restrict delete

fk_contact_request_translator_contact_request

contact_request_translator.contact_request_id

contact_request.contact_request_id

Restrict delete

fk_contact_request_translator_translator

contact_request_translator.translator_id

translator.translator_id

Restrict delete

fk_email_statistic_email_type

email_statistic.email_type

email_type.name

Restrict delete

fk_authorisation_term_reminder_authorisation

authorisation_term_reminder.authorisation_id

authorisation.authorisation_id

Restrict delete

fk_authorisation_term_reminder_email

authorisation_term_reminder.email_id

email.email_id

Restrict delete

Check Constraints

Table	Constraint Name	Constraint
authorisation	ck_authorisation_examination_date	(((((basis)::text = 'AUT'::text) AND (examination_date_id IS NOT NULL)) OR (((basis)::text <> 'AUT'::text) AND (examination_date_id IS NULL))))
authorisation	ck_authorisation_from_to	((((from_lang)::text <> (to_lang)::text) AND (((from_lang)::text = ANY (ARRAY[('FI'::character varying)::text, ('SV'::character varying)::text, ('SEIN'::character varying)::text, ('SEKO'::character varying)::text, ('SEPO'::character varying)::text])) OR ((to_lang)::text = ANY (ARRAY[('FI'::character varying)::text, ('SV'::character varying)::text, ('SEIN'::character varying)::text, ('SEKO'::character varying)::text, ('SEPO'::character varying)::text])))))
authorisation	ck_authorisation_term_begin_date	(((term_begin_date IS NOT NULL) OR ((basis)::text = 'VIR'::text)))
authorisation	ck_authorisation_term_end_date	(((((basis)::text <> 'VIR'::text) AND (term_end_date IS NOT NULL) AND (term_begin_date < term_end_date)) OR (((basis)::text = 'VIR'::text) AND (term_end_date IS NULL))))