SchemaSpy - Table harbinger.public.card_case_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('card_case_metadata_id_seq'::regclass)

metadata

text

2147483647

card_case_metadata_type_id

int8

19

exam_metadata_types.id

card_case_metadata_exam_metadata_type_fk R

card_case_id

int8

19

card_case_metadata_card_case_fk R

external_system_id

int8

19

external_systems.id

card_case_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	card_case_metadata_id
card_case_id	Performance	Asc	card_case_metadata_card_case_id_idx
card_case_metadata_type_id	Performance	Asc	card_case_metadata_card_case_metadata_type_id_idx
card_case_id + card_case_metadata_type_id + external_system_id	Performance	Asc/Asc/Asc	card_case_metadata_dm_idx
external_system_id	Performance	Asc	card_case_metadata_external_system_id_idx