enrollment


Columns

Column Type Size Nulls Auto Default Children Parents Comments
enrollment_id int8 19 √ null
payment.enrollment_id fk_payment_enrollment 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
exam_event_id int8 19 null
exam_event.exam_event_id fk_enrollment_exam_event R
person_id int8 19 null
person.person_id fk_enrollment_person R
skill_oral bool 1 null
skill_textual bool 1 null
skill_understanding bool 1 null
partial_exam_speaking bool 1 null
partial_exam_speech_comprehension bool 1 null
partial_exam_writing bool 1 null
partial_exam_reading_comprehension bool 1 null
status varchar 255 null
enrollment_status.name fk_enrollment_status R
previous_enrollment text 2147483647 √ null
digital_certificate_consent bool 1 null
email text 2147483647 null
phone_number text 2147483647 null
street text 2147483647 √ null
postal_code text 2147483647 √ null
town text 2147483647 √ null
country text 2147483647 √ null
payment_link_hash varchar 255 √ null
payment_link_expires_at timestamptz 35,6 √ null
free_enrollment int8 19 √ null
free_enrollment.free_enrollment_id fk_enrollment_free_enrollment R
is_queued bool 1 √ null
last_sync_at timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
enrollment_pkey Primary key Asc enrollment_id
enrollment_payment_link_hash_uniq_idx Must be unique Asc payment_link_hash
uk_enrollment_exam_event_person Must be unique Asc/Asc exam_event_id + person_id

Relationships

Close relationships within degrees of separation