Table harbinger.public.rad_reports
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_reports_id_seq'::regclass)
rad_exams.current_report_id rad_exam_current_report_fk R
rad_exams.first_final_report_id rad_exam_first_final_report_fk R
rad_exams.first_prelim_report_id rad_exam_first_prelim_report_fk R
rad_exams.first_report_id rad_exam_first_report_fk R
rad_exams.last_final_report_id rad_exam_last_final_report_fk R
rad_exams.last_prelim_report_id rad_exam_last_prelim_report_fk R
report_body text 2147483647  √  null
body_fts tsvector 2147483647  √  null
report_impression text 2147483647  √  null
impression_fts tsvector 2147483647  √  null
report_status_id int8 19  √  null
external_system_statuses.id report_status_fk R
transcriptionist_id int8 19  √  null
employees.id people_reports_fk R
rad1_id int8 19  √  null
employees.id people_reports_fk1 R
rad2_id int8 19  √  null
employees.id people_reports_fk2 R
rad3_id int8 19  √  null
employees.id people_reports_fk3 R
rad4_id int8 19  √  null
employees.id people_reports_fk4 R
rad_exam_id int8 19  √  null
rad_exams.id exam_fk R
report_event timestamptz 35,6  √  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_report_id
body_fts Performance Asc idx_fts_rad_reports_body
impression_fts Performance Asc idx_fts_rad_reports_impression
report_status_id Performance Asc rad_reports_external_system_status_id_idx
rad1_id Performance Asc rad_reports_rad1_id_idx
rad2_id Performance Asc rad_reports_rad2_id_idx
rad3_id Performance Asc rad_reports_rad3_id_idx
rad4_id Performance Asc rad_reports_rad4_id_idx
rad_exam_id Performance Asc rad_reports_rad_exam_id_idx
report_event Performance Asc rad_reports_report_event_idx
transcriptionist_id Performance Asc rad_reports_transcriptionist_id_idx
updated_at Performance Asc rad_reports_updated_idx

Close relationships  within of separation: