SchemaSpy - Table harbinger.public.patient_mrns

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

card_case_facts.patient_mrn_id	ByRailsConventionConstraint R
card_cases.patient_mrn_id	card_cases_patient_mrn_fk R
claims.patient_mrn_id	claim_patient_mrn_fk R
orders.patient_mrn_id	orders_patient_mrn_id_fk R
patient_demos.patient_mrn_id	patient_demos_patient_mrn_fk R
patient_demos_history.patient_mrn_id	patient_demos_history_patient_mrn_fk R
patient_events.patient_mrn_id	patient_events_patient_mrn_fk R
patient_events_history.patient_mrn_id	patient_events_patient_mrn_fk R
rad_exam_facts.patient_mrn_id	ByRailsConventionConstraint R
rad_exams.patient_mrn_id	rad_exam_patient_mrn_fk R
radonc_cases.patient_mrn_id	radonc_cases_patient_mrn_fk R
visits.patient_mrn_id	patient_mrn_id_fk R

mrn

text

2147483647

external_system_id

int8

19

external_systems.id

patient_mrns_extsys_fk R

patient_id

int8

19

patients.id

patient_mrns_patient_fk R

empi

bool

1

false

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	patient_mrn_id
external_system_id + mrn	Performance	Asc/Asc	patient_mrns_dm_idx
empi	Performance	Asc	patient_mrns_empi_idx
external_system_id	Performance	Asc	patient_mrns_extsys_idx
mrn	Performance	Asc	patient_mrns_mrn_idx
patient_id	Performance	Asc	patient_mrns_patient_id_idx