Table harbinger.public.insurance_policies
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('insurance_policies_id_seq'::regclass)
card_case_authorizations.insurance_policy_id card_case_authorizations_insurance_policy_fk R
claim_transaction_facts.insurance_policy_id claim_transaction_facts_insurance_policy_id_fk R
claim_transactions.insurance_policy_id claim_transaction_insurance_policy_fk R
rad_exam_authorizations.insurance_policy_id rad_exam_authorizations_insurance_policy_fk R
radonc_case_authorizations.insurance_policy_id radonc_case_authorizations_insurance_policy_fk R
visit_insurance_policies.insurance_policy_id visit_insurance_policies_insurance_policy_fk R
policy_holder_name text 2147483647
employer_name text 2147483647  √  null
insurance_carrier_plan_id int8 19  √  null
insurance_carrier_plans.id insurance_policy_insurance_carrier_plan_fk R
group_number text 2147483647  √  null
policy_number text 2147483647  √  null
relationship_type_id int8 19
relationship_types.id insurance_policy_relationship_type_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 insurance_policy_id
insurance_carrier_plan_id Performance Asc fki_insurance_policy_insurance_carrier_plan_fk
group_number + policy_number + insurance_carrier_plan_id Performance Asc/Asc/Asc insurance_policy_dm_idx
group_number Performance Asc insurance_policy_group_number_idx
policy_number Performance Asc insurance_policy_number_idx
relationship_type_id Performance Asc insurance_policy_relationship_fk

Close relationships  within of separation: