authorisation


Columns

Column Type Size Nulls Auto Default Children Parents Comments
authorisation_id int8 19 √ null
authorisation_term_reminder.authorisation_id fk_authorisation_term_reminder_authorisation R
version int4 10 0
created_by text 2147483647 √ null
modified_by text 2147483647 √ null
deleted_by text 2147483647 √ null
created_at timestamptz 35,6 now()
modified_at timestamptz 35,6 now()
deleted_at timestamptz 35,6 √ null
translator_id int8 19 null
translator.translator_id fk_authorisation_translator R
basis varchar 255 null
authorisation_basis.name fk_authorisation_authorisation_basis R
meeting_date_id int8 19 √ null
meeting_date.meeting_date_id fk_authorisation_meeting_date R
from_lang varchar 10 null
to_lang varchar 10 null
permission_to_publish bool 1 null
term_begin_date date 13 √ null
term_end_date date 13 √ null
diary_number varchar 255 √ null
examination_date_id int8 19 √ null
examination_date.examination_date_id fk_authorisation_examination_date R

Indexes

Constraint Name Type Sort Column(s)
authorisation_pkey Primary key Asc authorisation_id

Check Constraints

Constraint Name Constraint
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))))
ck_authorisation_term_begin_date (((term_begin_date IS NOT NULL) OR ((basis)::text = 'VIR'::text)))
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])))))
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))))

Relationships

Close relationships within degrees of separation