Table harbinger.public.cms_hcpcs_codes
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('cms_hcpcs_codes_id_seq'::regclass)
claim_transaction_facts.cms_hcpcs_code_id claim_transaction_facts_cms_hcpcs_code_id_fk R
claim_transactions.cms_hcpcs_code_id claim_transaction_cms_hcpcs_code_fk R
procedure_hcpcs_mappings.cms_hcpcs_code_id hcpcs_proc_hcpcs_mappings_fk R
hcpcs text 2147483647
description text 2147483647  √  null
modality_id int8 19  √  null
modalities.id cms_hcpcs_codes_modality_fk R
surgical bool 1 false
supply bool 1 false
work_rvu float8 17,17 0
nonfacility_pe_rvu float8 17,17 0
facility_pe_rvu float8 17,17 0
mp_rvu float8 17,17 0
conversion_factor float8 17,17 0
cms_modifier_id int8 19  √  null
cms_modifiers.id cms_hcpcs_codes_cms_modifier_fk R
cms_hcpcs_code_revision_id int8 19
cms_hcpcs_code_revisions.id cms_hcpcs_codes_revision_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 cms_hcpcs_code_id
hcpcs Performance Asc cms_hcpcs_codes_hcpcs_idx
modality_id Performance Asc cms_hcpcs_codes_modality_id_idx
cms_hcpcs_code_revision_id Performance Asc fki_cms_hcpcs_code_cms_hcpcs_code_revision_fk
cms_modifier_id Performance Asc fki_cms_hcpcs_code_cms_modifier_fk

Close relationships  within of separation: