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('claims_id_seq'::regclass)
card_case_claims.claim_id card_case_claims_claims_fk R
claim_transaction_facts.claim_id claim_transaction_facts_claim_id_fk R
claim_transactions.claim_id claim_transaction_claim_fk R
rad_exam_claims.claim_id rad_exam_claims_claim_fk R
radonc_case_claims.claim_id radonc_case_claims_claim_fk R
claim_number text 2147483647
external_system_id int8 19 claim_current_external_system_fk R
patient_mrn_id int8 19 claim_patient_mrn_fk R
site_id int8 19 claim_site_fk R
visit_id int8 19  √  null claim_visit_fk R
site_class_id int8 19  √  null claim_site_class_fk R
first_claim_transaction_id int8 19  √  null claim_first_claim_transaction_fk R
current_claim_transaction_id int8 19  √  null claim_current_claim_transaction_fk R
original_charge int8 19 0
current_balance int8 19 0
current_claim_status_id int8 19  √  null claim_current_external_system_status_fk R
current_carrier_id int8 19  √  null claim_current_carrier_fk R
charge_post timestamptz 35,6  √  null
claim_create timestamptz 35,6  √  null
zero_balance timestamptz 35,6  √  null
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

Column(s) Type Sort Constraint Name
id Primary key Asc claim_id
claim_number Performance Asc claim_claim_number_idx
external_system_id Performance Asc claim_external_system_fk
charge_post Performance Asc claims_charge_post
claim_create Performance Asc claims_claim_create
claim_number + external_system_id Performance Asc/Asc claims_dm_idx
zero_balance Performance Asc claims_zero_balance
current_carrier_id Performance Asc fki_claim_current_carrier_fk
current_claim_transaction_id Performance Asc fki_claim_current_claim_transaction_fk
current_claim_status_id Performance Asc fki_claim_current_external_system_status_fk
first_claim_transaction_id Performance Asc fki_claim_first_claim_transaction_fk
patient_mrn_id Performance Asc fki_claim_patient_mrn_fk
site_class_id Performance Asc fki_claim_site_class_fk
site_id Performance Asc fki_claim_site_fk
visit_id Performance Asc fki_claim_visit_fk

Close relationships  within of separation: