Table harbinger.public.site_locations
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_locations_id_seq'::regclass)
rad_exam_facts.site_location_id rad_exam_facts_site_location_id_fk R
site_sublocations.site_location_id location_fk R
name text 2147483647  √  null
external_system_id int8 19
external_systems.id site_location_external_system_id_fk R
location text 2147483647
site_id int8 19  √  null
sites.id site_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_location_id
location + external_system_id Performance Asc/Asc site_locations_dm_idx
external_system_id Performance Asc site_locations_extsys_idx
location Performance Asc site_locations_location_idx
site_id Performance Asc site_locations_site_id_idx

Close relationships  within of separation: