SchemaSpy - Table harbinger.public.icd_codes

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

claim_transaction_diagnoses.icd_code_id	claim_transaction_diagnoses_icd_code_fk R
visit_diagnoses.icd_code_id	visit_diagnoses_icd_code_fk R

code

text

2147483647

description

text

2147483647

√

null

icd_code_revision_id

int8

19

icd_code_revisions.id

icd_code_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	icd_code_id
icd_code_revision_id	Performance	Asc	fki_icd_code_revision_fk
code	Performance	Asc	icd_code_code_idx