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

metadata

text

2147483647

exam_metadata_type_id

int8

19

exam_metadata_types.id

exam_metadata_fk R

rad_exam_id

int8

19

exam_id_fk R

external_system_id

int8

19

external_systems.id

rad_exam_metadata_external_system_id_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	rad_exam_metadata_id
rad_exam_id + exam_metadata_type_id + external_system_id	Performance	Asc/Asc/Asc	rad_exam_metadata_dm_idx
exam_metadata_type_id	Performance	Asc	rad_exam_metadata_exam_metadata_type_id_idx
external_system_id	Performance	Asc	rad_exam_metadata_external_system_id_idx
rad_exam_id	Performance	Asc	rad_exam_metadata_rad_exam_id_idx