SchemaSpy - Table harbinger.public.site_sublocations

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

card_cases.site_sublocation_id	card_cases_site_sublocation_fk R
patient_events.postevent_site_sublocation_id	patient_events_site_sublocation_after_event_fk R
patient_events_history.postevent_site_sublocation_id	patient_events_history_postevent_site_sublocation_fk R
rad_exams.site_sublocation_id	rad_exam_site_sublocation_fk R
radonc_cases.site_sublocation_id	radonc_cases_site_sublocation_fk R

room

text

2147483647

√

null

bed

text

2147483647

√

null

site_location_id

int8

19

site_locations.id

location_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	site_sublocation_id
site_location_id	Performance	Asc	site_sublocation_site_location_idx
site_location_id + room + bed	Performance	Asc/Asc/Asc	site_sublocations_dm_idx