registration_change_event


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('registration_change_event_id_seq'::regclass)
exam_session_statistics.last_processed_event_id exam_session_statistics_last_processed_event_id_fkey R
event text 2147483647 null
registration_id bigserial 19 √ nextval('registration_change_event_registration_id_seq'::regclass)
registration.id registration_change_event_registration_id_fkey R
exam_session_id bigserial 19 √ nextval('registration_change_event_exam_session_id_seq'::regclass)
exam_session.id registration_change_event_exam_session_id_fkey R
registration_state registration_state 2147483647 null
registration_kind registration_kind 2147483647 null
original_exam_session_id int8 19 √ null
exam_session.id registration_change_event_original_exam_session_id_fkey R
created_at timestamptz 35,6 √ CURRENT_TIMESTAMP
created_by text 2147483647 √ null
author_type text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
registration_change_event_pkey Primary key Asc id
registration_change_event_exam_session_id_created_at Performance Asc/Asc exam_session_id + created_at
registration_change_event_original_exam_session_id_created_at Performance Asc/Asc original_exam_session_id + created_at

Relationships

Close relationships within degrees of separation