Table harbinger.public.rad_exam_times
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('rad_exam_times_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id exams_exam_times_fk R
order_arrival timestamptz 35,6  √  null
schedule_event timestamptz 35,6  √  null
reschedule_event timestamptz 35,6  √  null
appointment timestamptz 35,6  √  null
sign_in timestamptz 35,6  √  null
begin_reg timestamptz 35,6  √  null
check_in timestamptz 35,6  √  null
begin_exam timestamptz 35,6  √  null
begin_exam_event timestamptz 35,6  √  null
end_exam timestamptz 35,6  √  null
end_exam_event timestamptz 35,6  √  null
cancelled timestamptz 35,6  √  null
pacs_read_time timestamptz 35,6  √  null
appointment_duration int8 19  √  null
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc rad_exam_time_id
appointment Performance Asc rad_exam_times_appt_idx
begin_exam_event Performance Asc rad_exam_times_begin_exam_evt_idx
begin_exam Performance Asc rad_exam_times_begin_exam_idx
begin_reg Performance Asc rad_exam_times_begin_reg_idx
cancelled Performance Asc rad_exam_times_cancelled_idx
check_in Performance Asc rad_exam_times_checkin_idx
end_exam_event Performance Asc rad_exam_times_end_exam_evt_idx
end_exam Performance Asc rad_exam_times_end_exam_idx
order_arrival Performance Asc rad_exam_times_order_arrival_idx
rad_exam_id Performance Asc rad_exam_times_rad_exam_idx
reschedule_event Performance Asc rad_exam_times_reschedule_evt_idx
schedule_event Performance Asc rad_exam_times_schedule_evt_idx
sign_in Performance Asc rad_exam_times_signin_idx

Close relationships  within of separation: