Table harbinger.public.rad_exam_external_system_statuses
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_external_system_statuses_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id rad_exam_external_system_statuses_rad_exam_fk R
external_system_status_id int8 19
external_system_statuses.id rad_exam_external_system_statuses_external_system_status_fk R
external_system_id int8 19
external_systems.id rad_exam_external_system_statuses_external_system_fk R
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_external_system_statuses_id
rad_exam_id + external_system_id Performance Asc/Asc rad_exam_external_system_statuses_dm_idx
external_system_id Performance Asc rad_exam_external_system_statuses_external_system_id_idx
external_system_status_id Performance Asc rad_exam_external_system_statuses_external_system_status_id_idx
rad_exam_id Performance Asc rad_exam_external_system_statuses_rad_exam_id_idx

Close relationships  within of separation: