Table harbinger.public.cms_gpci
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_gpci_id_seq'::regclass)
sites.cms_gpci_id site_cms_gpci_fk R
carrier text 2147483647
locality text 2147483647
locality_name text 2147483647
work_gpci float8 17,17 0
pe_gpci float8 17,17 0
mp_gpci float8 17,17 0
cms_hcpcs_code_revision_id int8 19
cms_hcpcs_code_revisions.id cms_gpci_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_gpci_id
carrier + locality Performance Asc/Asc cms_gpci_locality_carrier_locality_idx
locality_name Performance Asc cms_gpci_locality_name_idx
cms_hcpcs_code_revision_id Performance Asc fki_cms_gpci_revision_fk

Close relationships  within of separation: