Table harbinger.public.procedure_hcpcs_mappings
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('procedure_hcpcs_mappings_id_seq'::regclass)
cms_hcpcs_code_id int8 19
cms_hcpcs_codes.id hcpcs_proc_hcpcs_mappings_fk R
procedure_id int8 19
procedures.id procedures_proc_hcpcs_mappings_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 procedure_hcpcs_mapping_id
cms_hcpcs_code_id Performance Asc procedure_hcpcs_mappings_cms_hcpcs_code_id_idx
procedure_id Performance Asc procedure_hcpcs_mappings_procedure_id_idx

Close relationships  within of separation: