qualification


Columns

Column Type Size Nulls Auto Default Children Parents Comments
qualification_id int8 19 √ null
qualification_reminder.qualification_id fk_qualification_reminder_qualification R
interpreter_id int8 19 null
interpreter.interpreter_id fk_qualification_interpreter R
modified_at timestamp 29,6 √ null
modified_by text 2147483647 √ null
created_at timestamp 29,6 now()
created_by text 2147483647 √ null
deleted_at timestamp 29,6 √ null
deleted_by text 2147483647 √ null
version int4 10 0
permission_to_publish bool 1 null
examination_type varchar 255 null
qualification_examination_type.name fk_qualification_examination_type R
from_lang varchar 10 null
to_lang varchar 10 null
begin_date date 13 null
end_date date 13 null
diary_number varchar 255 √ null
meeting_date_id int8 19 null
meeting_date.meeting_date_id fk_qualification_meeting_date R

Indexes

Constraint Name Type Sort Column(s)
qualification_pkey Primary key Asc qualification_id

Check Constraints

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

Relationships

Close relationships within degrees of separation