Table harbinger.public.card_case_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('card_case_facts_id_seq'::regclass)
card_case_id int8 19
card_cases.id card_case_facts_card_case_fk R
patient_id int8 19
patients.id ByRailsConventionConstraint R
patient_mrn_id int8 19
patient_mrns.id ByRailsConventionConstraint R
end_case_year int2 5
end_case_month int2 5
end_case_day int2 5
end_case_hour int2 5
end_case_minute int2 5
end_case_epoch int8 19
end_case_dow int2 5
end_case_woy int2 5
begin_case_year int2 5  √  null
begin_case_month int2 5  √  null
begin_case_day int2 5  √  null
begin_case_hour int2 5  √  null
begin_case_minute int2 5  √  null
begin_case_epoch int8 19  √  null
begin_case_dow int2 5  √  null
begin_case_woy int2 5  √  null
appointment_year int2 5  √  null
appointment_month int2 5  √  null
appointment_day int2 5  √  null
appointment_hour int2 5  √  null
appointment_minute int2 5  √  null
appointment_epoch int8 19  √  null
appointment_dow int2 5  √  null
appointment_woy int2 5  √  null
wheels_in_year int2 5  √  null
wheels_in_month int2 5  √  null
wheels_in_day int2 5  √  null
wheels_in_hour int2 5  √  null
wheels_in_minute int2 5  √  null
wheels_in_epoch int8 19  √  null
wheels_in_dow int2 5  √  null
wheels_in_woy int2 5  √  null
wheels_out_year int2 5  √  null
wheels_out_month int2 5  √  null
wheels_out_day int2 5  √  null
wheels_out_hour int2 5  √  null
wheels_out_minute int2 5  √  null
wheels_out_epoch int8 19  √  null
wheels_out_dow int2 5  √  null
wheels_out_woy int2 5  √  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
modality_id int8 19  √  null
modalities.id card_case_facts_modality_fk R
ordering_provider_id int8 19  √  null
employees.id card_case_facts_ordering_provider_fk R
procedure_ids _int8 19  √  null
procedure_specialty_ids _int8 19  √  null
volume int4 10  √  null
performing_id int8 19  √  null
employees.id card_case_facts_performing_fk R
performing_specialty_id int8 19  √  null
specialties.id card_case_facts_performing_specialty_fk R
anesthesiologist_id int8 19  √  null
employees.id card_case_facts_anesthesiologist_fk R
assisting_ids _int8 19  √  null
attending_id int8 19  √  null
employees.id card_case_facts_attending_fk R
cardiologist_id int8 19  √  null
employees.id card_case_facts_cardiologist_id_fk R
cardiologist_specialty_id int8 19  √  null
specialties.id card_case_facts_cardiologist_specialty_id_fk R
resident_id int8 19  √  null
employees.id card_case_facts_resident_id_fk R
case_priority_id int8 19  √  null
exam_priorities.id card_case_facts_case_priority_fk R
delay_reason_id int8 19  √  null
reasons.id card_case_facts_delay_reason_fk R
resource_id int8 19  √  null
resources.id card_case_facts_resource_fk R
service_id int8 19  √  null
services.id card_case_facts_service_fk R
site_id int8 19  √  null
sites.id card_case_facts_site_fk R
site_class_id int8 19  √  null
site_classes.id card_case_facts_site_class_fk R
technologist_id int8 19  √  null
employees.id card_case_facts_technologist_fk R
scheduler_id int8 19  √  null
employees.id card_case_facts_scheduler_fk R
ordering_id int8 19  √  null
employees.id card_case_facts_ordering_fk R
patient_type text 2147483647  √  null
patient_age int4 10  √  null
patient_priority text 2147483647  √  null
patient_priority_specified_date bool 1  √  null
pro_rvu float8 17,17  √  null
tech_rvu float8 17,17  √  null
reportable bool 1  √  null
access_wait int8 19  √  null
anesthesia_wait int8 19  √  null
case_duration int8 19  √  null
case_wait int8 19  √  null
encounter_duration int8 19  √  null
icu_recovery_duration int8 19  √  null
in_lab_patient_prep_duration int8 19  √  null
in_lab_post_procedure_duration int8 19  √  null
order_complete int8 19  √  null
patient_in_room_duration int8 19  √  null
pre_procedure_duration int8 19  √  null
prep_duration int8 19  √  null
procedure_wait int8 19  √  null
recovery_duration int8 19  √  null
reg_duration int8 19  √  null
reg_wait int8 19  √  null
total_care_time int8 19  √  null
total_wait int8 19  √  null
turn_around int8 19  √  null
wait_to_pre_procedure int8 19  √  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 card_case_facts_id
anesthesiologist_id Performance Asc card_case_fact_anesthesiologist_id_idx
appointment_day Performance Asc card_case_fact_appointment_day_idx
appointment_dow Performance Asc card_case_fact_appointment_dow_idx
appointment_epoch Performance Asc card_case_fact_appointment_epoch_idx
appointment_hour Performance Asc card_case_fact_appointment_hour_idx
appointment_minute Performance Asc card_case_fact_appointment_minute_idx
appointment_month Performance Asc card_case_fact_appointment_month_idx
appointment_woy Performance Asc card_case_fact_appointment_woy_idx
appointment_year Performance Asc card_case_fact_appointment_year_idx
attending_id Performance Asc card_case_fact_attending_id_idx
begin_case_day Performance Asc card_case_fact_begin_case_day_idx
begin_case_dow Performance Asc card_case_fact_begin_case_dow_idx
begin_case_epoch Performance Asc card_case_fact_begin_case_epoch_idx
begin_case_hour Performance Asc card_case_fact_begin_case_hour_idx
begin_case_minute Performance Asc card_case_fact_begin_case_minute_idx
begin_case_month Performance Asc card_case_fact_begin_case_month_idx
begin_case_woy Performance Asc card_case_fact_begin_case_woy_idx
begin_case_year Performance Asc card_case_fact_begin_case_year_idx
card_case_id Performance Asc card_case_fact_card_case_id_idx
cardiologist_id Performance Asc card_case_fact_cardiologist_id_idx
cardiologist_specialty_id Performance Asc card_case_fact_cardiologist_specialty_id_idx
case_priority_id Performance Asc card_case_fact_case_priority_id_idx
case_priority_id Performance Asc card_case_fact_case_priority_idx
delay_reason_id Performance Asc card_case_fact_delay_reason_id_idx
encounter_duration Performance Asc card_case_fact_encounter_duration_idx
end_case_day Performance Asc card_case_fact_end_case_day_idx
end_case_dow Performance Asc card_case_fact_end_case_dow_idx
end_case_epoch Performance Asc card_case_fact_end_case_epoch_idx
end_case_hour Performance Asc card_case_fact_end_case_hour_idx
end_case_minute Performance Asc card_case_fact_end_case_minute_idx
end_case_month Performance Asc card_case_fact_end_case_month_idx
end_case_woy Performance Asc card_case_fact_end_case_woy_idx
end_case_year Performance Asc card_case_fact_end_case_year_idx
final_report_day Performance Asc card_case_fact_final_report_day_idx
final_report_dow Performance Asc card_case_fact_final_report_dow_idx
final_report_epoch Performance Asc card_case_fact_final_report_epoch_idx
final_report_hour Performance Asc card_case_fact_final_report_hour_idx
final_report_minute Performance Asc card_case_fact_final_report_minute_idx
final_report_month Performance Asc card_case_fact_final_report_month_idx
final_report_woy Performance Asc card_case_fact_final_report_woy_idx
final_report_year Performance Asc card_case_fact_final_report_year_idx
first_report_day Performance Asc card_case_fact_first_report_day_idx
first_report_dow Performance Asc card_case_fact_first_report_dow_idx
first_report_epoch Performance Asc card_case_fact_first_report_epoch_idx
first_report_hour Performance Asc card_case_fact_first_report_hour_idx
first_report_minute Performance Asc card_case_fact_first_report_minute_idx
first_report_month Performance Asc card_case_fact_first_report_month_idx
first_report_woy Performance Asc card_case_fact_first_report_woy_idx
first_report_year Performance Asc card_case_fact_first_report_year_idx
in_lab_patient_prep_duration Performance Asc card_case_fact_in_lab_patient_prep_duration_idx
in_lab_post_procedure_duration Performance Asc card_case_fact_in_lab_post_procedure_duration_idx
modality_id Performance Asc card_case_fact_modality_id_idx
ordering_id Performance Asc card_case_fact_ordering_id_idx
ordering_provider_id Performance Asc card_case_fact_ordering_provider_id_idx
patient_age Performance Asc card_case_fact_patient_age_idx
patient_id Performance Asc card_case_fact_patient_id_idx
patient_mrn_id Performance Asc card_case_fact_patient_mrn_id_idx
patient_priority Performance Asc card_case_fact_patient_priority_idx
patient_priority_specified_date Performance Asc card_case_fact_patient_priority_specified_date_idx
patient_type Performance Asc card_case_fact_patient_type_idx
performing_id Performance Asc card_case_fact_performing_id_idx
performing_specialty_id Performance Asc card_case_fact_performing_specialty_id_idx
prelim_report_day Performance Asc card_case_fact_prelim_report_day_idx
prelim_report_dow Performance Asc card_case_fact_prelim_report_dow_idx
prelim_report_epoch Performance Asc card_case_fact_prelim_report_epoch_idx
prelim_report_hour Performance Asc card_case_fact_prelim_report_hour_idx
prelim_report_minute Performance Asc card_case_fact_prelim_report_minute_idx
prelim_report_month Performance Asc card_case_fact_prelim_report_month_idx
prelim_report_woy Performance Asc card_case_fact_prelim_report_woy_idx
prelim_report_year Performance Asc card_case_fact_prelim_report_year_idx
resident_id Performance Asc card_case_fact_resident_id_idx
resource_id Performance Asc card_case_fact_resource_id_idx
scheduler_id Performance Asc card_case_fact_scheduler_id_idx
service_id Performance Asc card_case_fact_service_id_idx
site_class_id Performance Asc card_case_fact_site_class_id_idx
site_id Performance Asc card_case_fact_site_id_idx
technologist_id Performance Asc card_case_fact_technologist_id_idx
wheels_in_day Performance Asc card_case_fact_wheels_in_day_idx
wheels_in_dow Performance Asc card_case_fact_wheels_in_dow_idx
wheels_in_epoch Performance Asc card_case_fact_wheels_in_epoch_idx
wheels_in_hour Performance Asc card_case_fact_wheels_in_hour_idx
wheels_in_minute Performance Asc card_case_fact_wheels_in_minute_idx
wheels_in_month Performance Asc card_case_fact_wheels_in_month_idx
wheels_in_woy Performance Asc card_case_fact_wheels_in_woy_idx
wheels_in_year Performance Asc card_case_fact_wheels_in_year_idx
wheels_out_day Performance Asc card_case_fact_wheels_out_day_idx
wheels_out_dow Performance Asc card_case_fact_wheels_out_dow_idx
wheels_out_epoch Performance Asc card_case_fact_wheels_out_epoch_idx
wheels_out_hour Performance Asc card_case_fact_wheels_out_hour_idx
wheels_out_minute Performance Asc card_case_fact_wheels_out_minute_idx
wheels_out_month Performance Asc card_case_fact_wheels_out_month_idx
wheels_out_woy Performance Asc card_case_fact_wheels_out_woy_idx
wheels_out_year Performance Asc card_case_fact_wheels_out_year_idx

Close relationships  within of separation: