Table harbinger.public.insurance_carrier_plans
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_carrier_plans_id_seq'::regclass)
claim_transaction_facts.insurance_carrier_plan_id claim_transaction_facts_insurance_carrier_plan_id_fk R
insurance_policies.insurance_carrier_plan_id insurance_policy_insurance_carrier_plan_fk R
insurance_carrier_id int8 19
insurance_carriers.id insurance_carrier_plan_insurance_carrier_fk R
plan_name text 2147483647
plan_number text 2147483647  √  null
insurance_carrier_plan_grouping_id int8 19  √  null
insurance_carrier_plan_groupings.id insurance_carrier_plan_grouping_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_carrier_plan_id
insurance_carrier_id Performance Asc fki_insurance_carrier_plan_insurance_carrier_fk
insurance_carrier_plan_grouping_id Performance Asc insurance_carrier_plan_grouping_idx
plan_name Performance Asc insurance_carrier_plan_name_idx
plan_number Performance Asc insurance_carrier_plan_number_idx

Close relationships  within of separation: