Table harbinger.public.external_systems
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('external_systems_id_seq'::regclass)
card_case_metadata.external_system_id card_case_metadata_external_system_fk R
card_cases.external_system_id card_cases_external_system_fk R
claims.external_system_id claim_current_external_system_fk R
dicom_protocols.external_system_id dicom_protocol_external_system_fk R
dicom_series.external_system_id dicom_series_external_system_fk R
dicom_studies.accession_external_system_id dicom_study_accession_external_system_fk R
dicom_studies.external_system_id dicom_study_external_system_fk R
external_system_role_mappings.external_system_id external_system_role_mappings_external_system_fk R
external_system_statuses.external_system_id external_system_statuses_external_system_status_fk R
identifiers.external_system_id external_system_fk R
insurance_carriers.external_system_id insurance_carrier_external_system_fk R
order_metadata.external_system_id order_metadata_external_system_fk R
orders.external_system_id orders_external_system_id R
patient_mrns.external_system_id patient_mrns_extsys_fk R
procedures.external_system_id sites_procedures_fk R
provider_groups.external_system_id provider_groups_external_system_fk R
rad_exam_external_system_statuses.external_system_id rad_exam_external_system_statuses_external_system_fk R
rad_exam_metadata.external_system_id rad_exam_metadata_external_system_id_fk R
rad_exams.external_system_id rad_exam_extsys_fk R
rad_pacs_metadata.external_system_id rad_pacs_external_system_fk R
radonc_cases.external_system_id radonc_cases_extsys_fk R
reasons.external_system_id reasons_extsys_fk R
resources.external_system_id resource_extsys_fk R
scheduling_task_groupings.external_system_id scheduling_task_gropuing_external_system_fk R
scheduling_tasks.external_system_id scheduling_task_external_system_fk R
site_classes.external_system_id site_classes_external_system_id_fk R
site_locations.external_system_id site_location_external_system_id_fk R
visits.external_system_id external_system_id_fk R
external_system text 2147483647
metasite_id int8 19
metasites.id external_system_site_fk R
integration_definition text 2147483647  √  null
identifier_padding_rules text 2147483647  √  null
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 external_systems_id
external_system + metasite_id Performance Asc/Asc external_systems_dm_idx
metasite_id Performance Asc external_systems_metasite_id_idx

Close relationships  within of separation: