Table harbinger.public.card_case_metrics
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_metrics_id_seq'::regclass)
card_case_id int8 19
card_cases.id card_case_metrics_card_case_fk R
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_metrics_id
card_case_id Performance Asc card_case_metrics_card_case_id_idx

Close relationships  within of separation: