registration


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('registration_id_seq'::regclass)
exam_payment_new.registration_id exam_payment_new_registration_id_fkey R
login_link.registration_id login_link_registration_id_fkey R
payment.registration_id payment_registration_id_fkey R
quarantine_review.registration_id quarantine_review_registration_id_fkey R
state registration_state 2147483647 null
exam_session_id int8 19 null
exam_session.id registration_exam_session_id_fkey R
participant_id int8 19 null
participant.id registration_participant_id_fkey R
started_at timestamptz 35,6 √ null
form jsonb 2147483647 √ null
form_version int4 10 √ null
person_oid text 2147483647 √ null
original_exam_session_id int8 19 √ null
exam_session.id registration_original_exam_session_id_fkey R
created timestamptz 35,6 √ CURRENT_TIMESTAMP
modified timestamptz 35,6 √ CURRENT_TIMESTAMP
kind registration_kind 2147483647 'ADMISSION'::registration_kind
is_transfered bool 1 false
lifted_from_queue_at timestamptz 35,6 √ null
expires_at timestamptz 35,6 √ null
exam_fee numeric 0 √ null
ui_language text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
registration_pkey Primary key Asc id
registration_exam_session_id Performance Asc exam_session_id
registration_lifted_from_queue_at Performance Asc lifted_from_queue_at
registration_person_oid Performance Asc person_oid
registration_state Performance Asc state

Relationships

Close relationships within degrees of separation