Table harbinger.public.radonc_cases
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('radonc_cases_id_seq'::regclass)
radonc_case_authorizations.radonc_case_id radonc_caseauthorizations_radonc_case_fk R
radonc_case_claims.radonc_case_id radonc_case_claims_radonc_case_fk R
case_number text 2147483647
external_system_id int8 19
external_systems.id radonc_cases_extsys_fk R
order_id int8 19  √  null
orders.id radonc_cases_order_fk R
visit_id int8 19  √  null
visits.id radonc_cases_visit_fk R
patient_mrn_id int8 19
patient_mrns.id radonc_cases_patient_mrn_fk R
site_class_id int8 19  √  null
site_classes.id radonc_cases_site_class_fk R
site_sublocation_id int8 19  √  null
site_sublocations.id radonc_cases_site_sublocation_fk R
procedure_id int8 19  √  null
procedures.id radonc_cases_procedure_fk R
exam_priority_id int8 19  √  null
exam_priorities.id radonc_cases_exam_priority_fk R
current_status_id int8 19
external_system_statuses.id radonc_cases_external_system_status_fk R
site_id int8 19
sites.id radonc_cases_site_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 radonc_cases_id
external_system_id Performance Asc radonccases_accextsys_idx
case_number Performance Asc radonccases_case_number_idx
current_status_id Performance Asc radonccases_currentstatus_idx
case_number + external_system_id Performance Asc/Asc radonccases_dm_idx
order_id Performance Asc radonccases_orderid_idx
patient_mrn_id Performance Asc radonccases_patient_mrn_id_idx
exam_priority_id Performance Asc radonccases_priority_idx
procedure_id Performance Asc radonccases_proc_idx
site_id Performance Asc radonccases_site_idx
site_sublocation_id Performance Asc radonccases_site_sublocation_idx
site_class_id Performance Asc radonccases_siteclass_idx
visit_id Performance Asc radonccases_visit_idx

Close relationships  within of separation: