Table harbinger.public.external_system_statuses
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_system_statuses_id_seq'::regclass)
card_cases.current_status_id card_cases_current_status_fk R
card_reports.report_status_id card_reports_report_status_fk R
claim_transaction_facts.claim_status_id claim_transaction_facts_claim_status_id_fk R
claim_transactions.claim_status_id claim_transaction_claim_status_external_system_status_fk R
claims.current_claim_status_id claim_current_external_system_status_fk R
orders.current_status_id orders_current_status_id R
patient_events.external_system_status_id patient_events_universal_event_type_fk R
patient_events_history.external_system_status_id patient_events_history_universal_event_type_fk R
rad_exam_external_system_statuses.external_system_status_id rad_exam_external_system_statuses_external_system_status_fk R
rad_exams.current_status_id rad_exam_external_system_status_fk R
rad_reports.report_status_id report_status_fk R
radonc_cases.current_status_id radonc_cases_external_system_status_fk R
status text 2147483647
external_system_id int8 19
external_systems.id external_system_statuses_external_system_status_fk R
universal_event_type_id int8 19  √  null
universal_event_types.id external_system_statuses_universal_event_type_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 external_system_status_id
status Performance Asc external_system_status_idx
external_system_id + status Performance Asc/Asc external_system_statuses_dm_idx
external_system_id Performance Asc external_system_statuses_external_system_id_idx
universal_event_type_id Performance Asc external_system_statuses_swim_status_id_idx

Close relationships  within of separation: