SchemaSpy - Table harbinger.public.insurance_carriers

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_carriers_id_seq'::regclass)

claim_transaction_facts.insurance_carrier_id	claim_transaction_facts_insurance_carrier_id_fk R
claim_transactions.carrier_id	claim_transaction_carrier_fk R
claims.current_carrier_id	claim_current_carrier_fk R
insurance_carrier_demographics.insurance_carrier_id	insurance_carrier_demographic_insurance_carrier_fk R
insurance_carrier_plans.insurance_carrier_id	insurance_carrier_plan_insurance_carrier_fk R

carrier

text

2147483647

external_system_id

int8

19

external_systems.id

insurance_carrier_external_system_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_id
carrier	Performance	Asc	insurance_carriers_carrier_idx
external_system_id	Performance	Asc	insurance_carriers_extsys_idx