Table harbinger.public.rad_exam_details
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_details_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id exams_exam_metadata_fk R
patient_age int4 10  √  null
procedure_modifier_id int8 19  √  null
procedure_modifiers.id procedure_modifiers_exam_metadata_fk R
previous_procedure_id int8 19  √  null
procedures.id procedures_exam_metadata_fk R
procedure_change_reason_id int8 19  √  null
reasons.id rad_exam_details_procedure_change_reason_fk R
delay_reason_id int8 19  √  null
reasons.id rad_exam_details_delay_reason_fk R
diagnosis text 2147483647  √  null
order_comments text 2147483647  √  null
procedure_change_comments text 2147483647  √  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_detail_id
delay_reason_id Performance Asc rad_exam_details_delay_reason_id_idx
previous_procedure_id Performance Asc rad_exam_details_previous_procedure_id_idx
procedure_change_reason_id Performance Asc rad_exam_details_procedure_change_reason_id_idx
procedure_modifier_id Performance Asc rad_exam_details_procedure_modifier_id_idx
rad_exam_id Performance Asc rad_exam_details_rad_exam_id_idx

Close relationships  within of separation: