exam_event


Columns

Column Type Size Nulls Auto Default Children Parents Comments
exam_event_id int8 19 √ null
enrollment.exam_event_id fk_enrollment_exam_event R
koski_educations.exam_event_id fk_koski_educations_exam_event R
reservation.exam_event_id fk_reservation_exam_event 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
language varchar 10 null
exam_language.name fk_exam_event_language R
level varchar 255 null
exam_level.name fk_exam_event_level R
date date 13 null
registration_closes timestamptz 35,6 null
is_hidden bool 1 null
max_participants int4 10 null
registration_opens timestamptz 35,6 null

Indexes

Constraint Name Type Sort Column(s)
exam_event_pkey Primary key Asc exam_event_id
uk_exam_event_language_level_date Must be unique Asc/Asc/Asc language + level + date

Check Constraints

Constraint Name Constraint
ck_exam_event_max_participants ((max_participants >= 0))

Relationships

Close relationships within degrees of separation