Table harbinger.public.rad_exam_facts
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_facts_id_seq'::regclass)
rad_exam_id int8 19
rad_exams.id rad_exam_facts_rad_exam_id_fk R
patient_id int8 19
patients.id ByRailsConventionConstraint R
patient_mrn_id int8 19
patient_mrns.id ByRailsConventionConstraint R
end_exam_year int2 5
end_exam_month int2 5
end_exam_day int2 5
end_exam_hour int2 5
end_exam_minute int2 5
end_exam_epoch int8 19
end_exam_dow int2 5
end_exam_woy int2 5
begin_exam_epoch int8 19  √  null
first_report_year int2 5  √  null
first_report_month int2 5  √  null
first_report_day int2 5  √  null
first_report_hour int2 5  √  null
first_report_minute int2 5  √  null
first_report_epoch int8 19  √  null
first_report_dow int2 5  √  null
first_report_woy int2 5  √  null
prelim_report_year int2 5  √  null
prelim_report_month int2 5  √  null
prelim_report_day int2 5  √  null
prelim_report_hour int2 5  √  null
prelim_report_minute int2 5  √  null
prelim_report_epoch int8 19  √  null
prelim_report_dow int2 5  √  null
prelim_report_woy int2 5  √  null
final_report_year int2 5  √  null
final_report_month int2 5  √  null
final_report_day int2 5  √  null
final_report_hour int2 5  √  null
final_report_minute int2 5  √  null
final_report_epoch int8 19  √  null
final_report_dow int2 5  √  null
final_report_woy int2 5  √  null
dicom_begin_epoch int8 19  √  null
dicom_end_year int2 5  √  null
dicom_end_month int2 5  √  null
dicom_end_day int2 5  √  null
dicom_end_hour int2 5  √  null
dicom_end_minute int2 5  √  null
dicom_end_epoch int8 19  √  null
dicom_end_dow int2 5  √  null
dicom_end_woy int2 5  √  null
modality_id int8 19  √  null
modalities.id rad_exam_facts_modality_id_fk R
ordering_provider_id int8 19  √  null
employees.id rad_exam_facts_ordering_provider_id_fk R
patient_type text 2147483647  √  null
procedure_id int8 19  √  null
procedures.id rad_exam_facts_procedure_id_fk R
procedure_specialty_id int8 19  √  null
specialties.id rad_exam_facts_procedure_specialty_id_fk R
reportable bool 1  √  null
volume int4 10  √  null
radiologist_id int8 19  √  null
employees.id rad_exam_facts_radiologist_id_fk R
radiologist_specialty_id int8 19  √  null
specialties.id rad_exam_facts_radiologist_specialty_id_fk R
resident_id int8 19  √  null
employees.id rad_exam_facts_resident_id_fk R
exam_priority_id int8 19  √  null
exam_priorities.id rad_exam_facts_delay_exam_priority_id_fk R
site_location_id int8 19  √  null
site_locations.id rad_exam_facts_site_location_id_fk R
patient_age int4 10  √  null
delay_reason_id int8 19  √  null
reasons.id rad_exam_facts_delay_reason_id_fk R
resource_id int8 19  √  null
resources.id rad_exam_facts_resource_id_fk R
site_id int8 19  √  null
sites.id rad_exam_facts_site_id_fk R
rad_exam_department_id int8 19  √  null
rad_exam_departments.id rad_exam_facts_rad_exam_department_id_fk R
service_id int8 19  √  null
services.id rad_exam_facts_service_id_fk R
site_class_id int8 19  √  null
site_classes.id rad_exam_facts_site_class_id_fk R
technologist_id int8 19  √  null
employees.id rad_exam_facts_technologist_id_fk R
scheduler_id int8 19  √  null
employees.id rad_exam_facts_scheduler_id_fk R
patient_priority text 2147483647  √  null
patient_priority_specified_date bool 1  √  null
rad_pacs_bodypart_id int8 19  √  null
rad_pacs_bodyparts.id rad_exam_facts_rad_pacs_bodypart_id_fk R
rad_pacs_modality_id int8 19  √  null
rad_pacs_modalities.id rad_exam_facts_rad_pacs_modality_id_fk R
rad_pacs_aet_id int8 19  √  null
rad_pacs_aets.id rad_exam_facts_rad_pacs_aet_id_fk R
manufacturer_id int8 19  √  null
manufacturers.id rad_exam_facts_manufacturer_id_fk R
equipment_model_id int8 19  √  null
equipment_models.id rad_exam_facts_equipment_model_id_fk R
equipment_serial_number_id int8 19  √  null
equipment_serial_numbers.id rad_exam_facts_equipment_serial_number_id_fk R
pro_rvu float8 17,17  √  null
tech_rvu float8 17,17  √  null
access_wait int8 19  √  null
transport int8 19  √  null
encounter_duration int8 19  √  null
reg_wait int8 19  √  null
reg_duration int8 19  √  null
exam_wait int8 19  √  null
exam_duration int8 19  √  null
total_wait int8 19  √  null
order_complete int8 19  √  null
first_report_turn_around int8 19  √  null
prelim_turn_around int8 19  √  null
turn_around int8 19  √  null
schedule_first_report int8 19  √  null
schedule_first_prelim int8 19  √  null
schedule_first_final int8 19  √  null
order_first_report int8 19  √  null
order_first_prelim int8 19  √  null
order_first_final int8 19  √  null
order_first_image int8 19  √  null
order_last_image int8 19  √  null
first_image_prelim int8 19  √  null
last_image_prelim int8 19  √  null
first_image_final int8 19  √  null
last_image_final int8 19  √  null
end_exam_first_image int8 19  √  null
end_exam_last_image int8 19  √  null
send_duration int8 19  √  null
send_delay int8 19  √  null
acquisition_duration int8 19  √  null
order_begin_acquisition int8 19  √  null
order_end_acquisition int8 19  √  null
acquisition_wait int8 19  √  null
acquisition_delay int8 19  √  null
acquisition_ready int8 19  √  null
acquisition_first_report int8 19  √  null
acquisition_first_prelim int8 19  √  null
acquisition_first_final int8 19  √  null
charges int8 19  √  null
payments int8 19  √  null
adjustments int8 19  √  null
accounts_receivable int8 19  √  null
appointment_duration int8 19  √  null
scheduling_specialty_id int8 19  √  null
specialties.id rad_exam_facts_scheduling_specialty_id_fk R
scheduling_site_id int8 19  √  null
sites.id rad_exam_facts_scheduling_site_id_fk R
scheduling_rad_exam_department_id int8 19  √  null
rad_exam_departments.id rad_exam_facts_scheduling_rad_exam_department_id_fk R
scheduling_service_id int8 19  √  null
services.id rad_exam_facts_scheduling_service_id_fk R
acquisition_interseries_delay int8 19  √  null
acquisition_series_duration int8 19  √  null
image_count int8 19  √  null
series_count int8 19  √  null
ordering_provider_group_id int8 19  √  null
provider_groups.id rad_exam_facts_ordering_provider_group_id_fk R
ordering_department_id int8 19  √  null
ordering_departments.id rad_exam_facts_ordering_department_id_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_facts_id
begin_exam_epoch Performance Asc rad_exam_fact_begin_exam_epoch_idx
delay_reason_id Performance Asc rad_exam_fact_delay_reason_id_idx
dicom_begin_epoch Performance Asc rad_exam_fact_dicom_begin_epoch_idx
dicom_end_day Performance Asc rad_exam_fact_dicom_end_day_idx
dicom_end_dow Performance Asc rad_exam_fact_dicom_end_dow_idx
dicom_end_epoch Performance Asc rad_exam_fact_dicom_end_epoch_idx
dicom_end_hour Performance Asc rad_exam_fact_dicom_end_hour_idx
dicom_end_minute Performance Asc rad_exam_fact_dicom_end_minute_idx
dicom_end_month Performance Asc rad_exam_fact_dicom_end_month_idx
dicom_end_woy Performance Asc rad_exam_fact_dicom_end_woy_idx
dicom_end_year Performance Asc rad_exam_fact_dicom_end_year_idx
end_exam_day Performance Asc rad_exam_fact_end_exam_day_idx
end_exam_dow Performance Asc rad_exam_fact_end_exam_dow_idx
end_exam_epoch Performance Asc rad_exam_fact_end_exam_epoch_idx
end_exam_hour Performance Asc rad_exam_fact_end_exam_hour_idx
end_exam_minute Performance Asc rad_exam_fact_end_exam_minute_idx
end_exam_month Performance Asc rad_exam_fact_end_exam_month_idx
end_exam_woy Performance Asc rad_exam_fact_end_exam_woy_idx
end_exam_year Performance Asc rad_exam_fact_end_exam_year_idx
equipment_model_id Performance Asc rad_exam_fact_equipment_model_id_idx
equipment_serial_number_id Performance Asc rad_exam_fact_equipment_serial_number_id_idx
exam_priority_id Performance Asc rad_exam_fact_exam_priority_id_idx
final_report_day Performance Asc rad_exam_fact_final_report_day_idx
final_report_dow Performance Asc rad_exam_fact_final_report_dow_idx
final_report_epoch Performance Asc rad_exam_fact_final_report_epoch_idx
final_report_hour Performance Asc rad_exam_fact_final_report_hour_idx
final_report_minute Performance Asc rad_exam_fact_final_report_minute_idx
final_report_month Performance Asc rad_exam_fact_final_report_month_idx
final_report_woy Performance Asc rad_exam_fact_final_report_woy_idx
final_report_year Performance Asc rad_exam_fact_final_report_year_idx
first_report_day Performance Asc rad_exam_fact_first_report_day_idx
first_report_dow Performance Asc rad_exam_fact_first_report_dow_idx
first_report_epoch Performance Asc rad_exam_fact_first_report_epoch_idx
first_report_hour Performance Asc rad_exam_fact_first_report_hour_idx
first_report_minute Performance Asc rad_exam_fact_first_report_minute_idx
first_report_month Performance Asc rad_exam_fact_first_report_month_idx
first_report_woy Performance Asc rad_exam_fact_first_report_woy_idx
first_report_year Performance Asc rad_exam_fact_first_report_year_idx
manufacturer_id Performance Asc rad_exam_fact_manufacturer_id_idx
modality_id Performance Asc rad_exam_fact_modality_id_idx
ordering_department_id Performance Asc rad_exam_fact_ordering_department_id_idx
ordering_provider_group_id Performance Asc rad_exam_fact_ordering_provider_group_id_idx
ordering_provider_id Performance Asc rad_exam_fact_ordering_provider_id_idx
patient_age Performance Asc rad_exam_fact_patient_age_idx
patient_id Performance Asc rad_exam_fact_patient_id_idx
patient_mrn_id Performance Asc rad_exam_fact_patient_mrn_id_idx
patient_priority Performance Asc rad_exam_fact_patient_priority_idx
patient_priority_specified_date Performance Asc rad_exam_fact_patient_priority_specified_date_idx
patient_type Performance Asc rad_exam_fact_patient_type_idx
prelim_report_day Performance Asc rad_exam_fact_prelim_report_day_idx
prelim_report_dow Performance Asc rad_exam_fact_prelim_report_dow_idx
prelim_report_epoch Performance Asc rad_exam_fact_prelim_report_epoch_idx
prelim_report_hour Performance Asc rad_exam_fact_prelim_report_hour_idx
prelim_report_minute Performance Asc rad_exam_fact_prelim_report_minute_idx
prelim_report_month Performance Asc rad_exam_fact_prelim_report_month_idx
prelim_report_woy Performance Asc rad_exam_fact_prelim_report_woy_idx
prelim_report_year Performance Asc rad_exam_fact_prelim_report_year_idx
procedure_id Performance Asc rad_exam_fact_procedure_id_idx
procedure_specialty_id Performance Asc rad_exam_fact_procedure_specialty_id_idx
rad_exam_department_id Performance Asc rad_exam_fact_rad_exam_department_id_idx
rad_exam_id Performance Asc rad_exam_fact_rad_exam_id_idx
rad_pacs_aet_id Performance Asc rad_exam_fact_rad_pacs_aet_id_idx
rad_pacs_bodypart_id Performance Asc rad_exam_fact_rad_pacs_bodypart_id_idx
rad_pacs_modality_id Performance Asc rad_exam_fact_rad_pacs_modality_id_idx
radiologist_id Performance Asc rad_exam_fact_radiologist_id_idx
radiologist_specialty_id Performance Asc rad_exam_fact_radiologist_specialty_id_idx
reportable Performance Asc rad_exam_fact_reportable_idx
resident_id Performance Asc rad_exam_fact_resident_id_idx
resource_id Performance Asc rad_exam_fact_resource_id_idx
scheduler_id Performance Asc rad_exam_fact_scheduler_id_idx
scheduling_rad_exam_department_id Performance Asc rad_exam_fact_scheduling_rad_exam_department_id_idx
scheduling_service_id Performance Asc rad_exam_fact_scheduling_service_id_idx
scheduling_site_id Performance Asc rad_exam_fact_scheduling_site_id_idx
scheduling_specialty_id Performance Asc rad_exam_fact_scheduling_specialty_id_idx
service_id Performance Asc rad_exam_fact_service_id_idx
site_class_id Performance Asc rad_exam_fact_site_class_id_idx
site_id Performance Asc rad_exam_fact_site_id_idx
site_location_id Performance Asc rad_exam_fact_site_location_id_idx
technologist_id Performance Asc rad_exam_fact_technologist_id_idx

Close relationships  within of separation: