Table harbinger.public.site_sublocations
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 location_fk R
updated_at timestamptz 35,6 now()

Analyzed at Tue Aug 16 14:31 UTC 2022

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

Close relationships  within of separation: