Table harbinger.public.procedures
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('procedures_id_seq'::regclass)
card_case_details.previous_procedure_id card_case_details_previous_procedure_fk R
card_case_procedure_mappings.procedure_id card_case_procedure_mappings_procedure_fk R
dicom_studies.procedure_id dicom_study_procedure_id_fk R
order_procedure_mappings.procedure_id order_procedure_mappings_procedure_fk R
procedure_hcpcs_mappings.procedure_id procedures_proc_hcpcs_mappings_fk R
rad_exam_details.previous_procedure_id procedures_exam_metadata_fk R
rad_exam_facts.procedure_id rad_exam_facts_procedure_id_fk R
rad_exams.procedure_id rad_exam_procedure_fk R
radonc_cases.procedure_id radonc_cases_procedure_fk R
external_system_id int8 19
external_systems.id sites_procedures_fk R
code text 2147483647
description text 2147483647  √  null
volume int4 10 1
reportable bool 1  √  true
scheduled_duration int4 10  √  null
specialty_id int8 19  √  null
specialties.id specialties_procedures_fk R
pro_rvu float8 17,17 0
tech_rvu float8 17,17 0
practice_fee int8 19 0
pro_fee int8 19 0
tech_fee int8 19 0
active bool 1 true
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 procedure_id
code Performance Asc procedure_code_idx
code + external_system_id Performance Asc/Asc procedure_dm_idx
external_system_id Performance Asc procedure_extsys_idx
volume Performance Asc procedure_volume_idx
specialty_id Performance Asc procedures_specialty_id_idx

Close relationships  within of separation: