Table harbinger.public.orders
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('orders_id_seq'::regclass)
card_cases.order_id card_cases_order_fk R
order_metadata.order_id order_metadata_order_fk R
order_procedure_mappings.order_id order_procedure_mappings_order_fk R
orders.master_order_id orders_master_order_fk R
rad_exams.order_id rad_exam_order_fk R
radonc_cases.order_id radonc_cases_order_fk R
order_number text 2147483647  √  null
external_system_id int8 19
external_systems.id orders_external_system_id R
current_status_id int8 19  √  null
external_system_statuses.id orders_current_status_id R
patient_mrn_id int8 19
patient_mrns.id orders_patient_mrn_id_fk R
visit_id int8 19  √  null
visits.id visits_orders_fk R
site_class_id int8 19  √  null
site_classes.id orders_site_class_fk R
department_id int8 19
departments.id orders_departments_fk R
master_order_id int8 19  √  null
orders.id orders_master_order_fk R
site_id int8 19
sites.id orders_site_fk R
resource_id int8 19  √  null
resources.id orders_resources_fk R
exam_priority_id int8 19  √  null
exam_priorities.id orders_exam_priorities_fk R
order_arrival timestamptz 35,6  √  null
appointment timestamptz 35,6  √  null
appointment_duration int8 19  √  null
ordering_provider_id int8 19  √  null
employees.id orders_ordering_provider_fk R
ordering_provider_group_id int8 19  √  null
provider_groups.id orders_ordering_provider_groups_fk R
ordering_department_id int8 19  √  null
ordering_departments.id orders_ordering_department_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 orders_id
appointment Performance Asc order_appointment_idx
exam_priority_id Performance Asc order_exam_priority_fk_idx
order_number Performance Asc order_order_number_idx
site_class_id Performance Asc order_site_class_fk_idx
current_status_id Performance Asc orders_current_status_id_idx
department_id Performance Asc orders_department_id_idx
order_number + external_system_id Performance Asc/Asc orders_dm_idx
external_system_id Performance Asc orders_extsys_id_idx
master_order_id Performance Asc orders_master_order_id_idx
order_arrival Performance Asc orders_order_arrival_idx
ordering_department_id Performance Asc orders_ordering_department_id_idx
ordering_provider_group_id Performance Asc orders_ordering_provider_group_id_idx
ordering_provider_id Performance Asc orders_ordering_provider_id_idx
patient_mrn_id Performance Asc orders_patient_mrn_id_idx
resource_id Performance Asc orders_resource_id_idx
site_id Performance Asc orders_site_id_idx
visit_id Performance Asc orders_visit_id_idx

Close relationships  within of separation: