exam_session


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('exam_session_id_seq'::regclass)
exam_session_contact.exam_session_id exam_session_contact_exam_session_id_fkey C
exam_session_location.exam_session_id exam_session_location_exam_session_id_fkey C
exam_session_queue.exam_session_id exam_session_queue_exam_session_id_fkey C
exam_session_statistics.exam_session_id exam_session_statistics_exam_session_id_fkey R
exam_session_ticket.exam_session_id fk_exam_session_ticket_exam_session R
login_link.exam_session_id login_link_exam_session_id_fkey R
participant_sync_status.exam_session_id participant_sync_status_exam_session_id_fkey R
registration.exam_session_id registration_exam_session_id_fkey R
registration.original_exam_session_id registration_original_exam_session_id_fkey R
registration_change_event.exam_session_id registration_change_event_exam_session_id_fkey R
registration_change_event.original_exam_session_id registration_change_event_original_exam_session_id_fkey R
organizer_id bigserial 19 √ nextval('exam_session_organizer_id_seq'::regclass)
organizer.id exam_session_organizer_id_fkey R
language_code bpchar 3 null
language.code exam_session_language_code_fkey R
level_code text 2147483647 null
exam_level.code exam_session_level_code_fkey R
exam_date_id bigserial 19 √ nextval('exam_session_exam_date_id_seq'::regclass)
exam_date.id exam_session_exam_date_id_fkey R
max_participants int4 10 null
office_oid text 2147483647 √ null
published_at timestamptz 35,6 √ null
created timestamptz 35,6 √ CURRENT_TIMESTAMP
modified timestamptz 35,6 √ CURRENT_TIMESTAMP
post_admission_start_date date 13 √ null
post_admission_active bool 1 √ false
post_admission_quota int8 19 √ null
post_admission_activated_at date 13 √ null
contact_name text 2147483647 √ null
contact_email text 2147483647 √ null
contact_phone_number text 2147483647 √ null
type exam_session_type 2147483647 'FULL'::exam_session_type

Indexes

Constraint Name Type Sort Column(s)
exam_session_pkey Primary key Asc id
exam_session_organizer_id_office_oid_language_code_level_co_key Must be unique Asc/Asc/Asc/Asc/Asc organizer_id + office_oid + language_code + level_code + exam_date_id

Relationships

Close relationships within degrees of separation