Table harbinger.public.rad_exams
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_exams_id_seq'::regclass)
dicom_studies.rad_exam_id dicom_study_rad_exams_fk R
rad_exam_authorizations.rad_exam_id rad_exam_authorizations_rad_exam_fk R
rad_exam_claim_transactions.rad_exam_id rad_exam_claim_transactions_rad_exam_fk R
rad_exam_claims.rad_exam_id rad_exam_claims_rad_exam_fk R
rad_exam_details.rad_exam_id exams_exam_metadata_fk R
rad_exam_external_system_statuses.rad_exam_id rad_exam_external_system_statuses_rad_exam_fk R
rad_exam_facts.rad_exam_id rad_exam_facts_rad_exam_id_fk R
rad_exam_metadata.rad_exam_id exam_id_fk R
rad_exam_metrics.rad_exam_id exam_metric_fk R
rad_exam_personnel.rad_exam_id exams_exam_personnel_fk R
rad_exam_times.rad_exam_id exams_exam_times_fk R
rad_pacs_metadata.rad_exam_id exams_rad_pacs_metadata_fk R
rad_reports.rad_exam_id exam_fk R
accession text 2147483647
external_system_id int8 19
external_systems.id rad_exam_extsys_fk R
order_id int8 19  √  null
orders.id rad_exam_order_fk R
visit_id int8 19  √  null
visits.id rad_exam_visit_fk R
patient_mrn_id int8 19
patient_mrns.id rad_exam_patient_mrn_fk R
site_class_id int8 19  √  null
site_classes.id rad_exam_site_class_fk R
site_sublocation_id int8 19  √  null
site_sublocations.id rad_exam_site_sublocation_fk R
procedure_id int8 19  √  null
procedures.id rad_exam_procedure_fk R
resource_id int8 19  √  null
resources.id rad_exam_resource_fk R
exam_priority_id int8 19  √  null
exam_priorities.id rad_exam_exam_priority_fk R
rad_exam_department_id int8 19  √  null
rad_exam_departments.id rad_exam_rad_exam_dept_fk R
service_id int8 19  √  null
services.id rad_exam_service_fk R
first_prelim_report_id int8 19  √  null
rad_reports.id rad_exam_first_prelim_report_fk R
last_prelim_report_id int8 19  √  null
rad_reports.id rad_exam_last_prelim_report_fk R
first_final_report_id int8 19  √  null
rad_reports.id rad_exam_first_final_report_fk R
last_final_report_id int8 19  √  null
rad_reports.id rad_exam_last_final_report_fk R
current_status_id int8 19
external_system_statuses.id rad_exam_external_system_status_fk R
first_report_id int8 19  √  null
rad_reports.id rad_exam_first_report_fk R
current_report_id int8 19  √  null
rad_reports.id rad_exam_current_report_fk R
site_id int8 19
sites.id rad_exam_site_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_id
accession Performance Asc radexam_acc_idx
external_system_id Performance Asc radexam_accextsys_idx
current_report_id Performance Asc radexam_currentreportid_idx
current_status_id Performance Asc radexam_currentstatus_idx
accession + external_system_id Performance Asc/Asc radexam_dm_idx
first_final_report_id Performance Asc radexam_firstfinalreportid_idx
first_prelim_report_id Performance Asc radexam_firstprelimreportid_idx
first_report_id Performance Asc radexam_firstreportid_idx
last_final_report_id Performance Asc radexam_lastfinalreportid_idx
last_prelim_report_id Performance Asc radexam_lastprelimreportid_idx
order_id Performance Asc radexam_orderid_idx
patient_mrn_id Performance Asc radexam_patient_mrn_id_idx
exam_priority_id Performance Asc radexam_priority_idx
procedure_id Performance Asc radexam_proc_idx
rad_exam_department_id Performance Asc radexam_radexamdept_idx
resource_id Performance Asc radexam_res_idx
service_id Performance Asc radexam_service_idx
site_id Performance Asc radexam_site_idx
site_sublocation_id Performance Asc radexam_site_sublocation_idx
site_class_id Performance Asc radexam_siteclass_idx
visit_id Performance Asc radexam_visit_idx

Close relationships  within of separation: