SchemaSpy - Table harbinger.public.visits

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

card_cases.visit_id	card_cases_visit_fk R
claims.visit_id	claim_visit_fk R
orders.visit_id	visits_orders_fk R
patient_demos.visit_id	visit_fk R
patient_demos_history.visit_id	visit_fk R
patient_events.visit_id	patient_events_visit_fk R
patient_events_history.visit_id	patient_events_history_visit_fk R
rad_exams.visit_id	rad_exam_visit_fk R
radonc_cases.visit_id	radonc_cases_visit_fk R
visit_diagnoses.visit_id	visit_diagnoses_visit_fk R
visit_insurance_policies.visit_id	visit_insurance_policies_visit_fk R

visit_number

text

2147483647

√

null

external_system_id

int8

19

external_systems.id

external_system_id_fk R

patient_mrn_id

int8

19

patient_mrns.id

patient_mrn_id_fk R

site_id

int8

19

√

null

sites.id

visits_site_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	visit_id
external_system_id + visit_number	Performance	Asc/Asc	visits_dm_idx
external_system_id	Performance	Asc	visits_extsys_idx
patient_mrn_id	Performance	Asc	visits_patient_mrn_id_idx
site_id	Performance	Asc	visits_site_id_idx
visit_number	Performance	Asc	visits_visit_idx