Table harbinger.public.resources
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('resources_id_seq'::regclass)
card_case_facts.resource_id card_case_facts_resource_fk R
card_cases.resource_id card_cases_resource_fk R
orders.resource_id orders_resources_fk R
rad_exam_facts.resource_id rad_exam_facts_resource_id_fk R
rad_exams.resource_id rad_exam_resource_fk R
external_system_id int8 19
external_systems.id resource_extsys_fk R
resource text 2147483647
name text 2147483647  √  null
modality_id int8 19  √  null
modalities.id modalities_resources_fk R
site_id int8 19
sites.id resource_site_fk R
rad_pacs_aet_id int8 19  √  null
rad_pacs_aets.id resource_rad_pacs_aet_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 resource_id
resource + external_system_id Performance Asc/Asc resource_dm_idx
external_system_id Performance Asc resource_extsys_idx
resource Performance Asc resource_res_idx
site_id Performance Asc resource_site_idx
modality_id Performance Asc resources_modality_id_idx
rad_pacs_aet_id Performance Asc resources_rad_pacs_aet_id_idx
site_id Performance Asc resources_site_id_idx

Close relationships  within of separation: