SchemaSpy - Table harbinger.public.order_metadata

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

metadata

text

2147483647

order_metadata_type_id

int8

19

exam_metadata_types.id

order_metadata_exam_metadata_type_fk R

order_id

int8

19

orders.id

order_metadata_order_fk R

external_system_id

int8

19

external_systems.id

order_metadata_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	order_metadata_id
order_id + order_metadata_type_id + external_system_id	Performance	Asc/Asc/Asc	order_metadata_dm_idx
external_system_id	Performance	Asc	order_metadata_external_system_id_idx
order_id	Performance	Asc	order_metadata_order_id_idx
order_metadata_type_id	Performance	Asc	order_metadata_order_metadata_type_id_idx