| ID Field | Foreign Keys | One-to-Many | Many-to-One |
|---|---|---|---|
| [abbreviation]ID | |||
| [account]ID | [item]account_income_ID | - | - |
| [account]ID | [item]account_purchases_ID | - | - |
| [account]ID | [item]account_stock_ID | - | - |
| [account]ID | [period_amount]account_code_ID | - | - |
| [Admitted_from]ID | |||
| [asset]ID | [log]source_record_ID [HIS_ENCOUNTER]ADMITTED_FROM_ID | ||
| [asset_condition]ID | [asset]condition_id | ||
| [asset_location]ID | [asset]location_id | ||
| [asset_status]ID | [asset]status_id | ||
| [asset_type]ID | [asset]type_id | ||
| [backorder]ID | [trans_line]source_backorder_id | ||
| [bill_of_material]ID | |||
| [bom_master]ID | [bill_of_material]BOM_master_id | ||
| [box]ID | [box_line]box_ID | - | - |
| [box_line]ID | |||
| [budget_period]ID | [transact]budget_period_ID [Goods_received]budget_ID [purchase_order]budget_period_ID [name_budget]budget_period_ID [period_amount]budget_period_ID | ||
| [clinician]ID | [transact]prescriber_ID [HIS_ENCOUNTER_DISEASE]DIAGNOZED_BY | ||
| [contact]ID | [contact_group_membership]contact_id [transact]contact_id | ||
| [contact_group]ID | [contact_group_membership]contact_group_id | ||
| [contact_group_membership]ID | |||
| [currency]ID | [purchase_order]currency_ID [quote_line]currency_ID [transact]currency_ID [name]currency_ID [quote]currency_ID | ||
| [custom_data]ID | |||
| [custom_data_category]ID | [custom_data]category_id | ||
| [dashboard_report]ID | |||
| [DOC_REFERENCE]ID | |||
| [Drug_interaction]ID | |||
| [Drug_interaction_group]ID | [Drug_interaction]affected_group_ID [Drug_interaction]affecting_group_ID [item]interaction_group_ID | ||
| [Drug_register]ID | [Drug_interaction]source_ID | ||
| [drug_register_category1]ID | [Drug_register]category1_ID | ||
| [drug_register_category2]ID | [Drug_register]category2_ID | ||
| [Ethnicity]ID | [name]ethnicity_ID | ||
| [Goods_received]ID | [Goods_received_line]goods_received_ID [transact]goods_received_ID | ||
| [Goods_received_line]ID | [trans_line]goods_received_lines_ID | ||
| [HIS_BED]ID | [HIS_ENCOUNTER_LOCATION]BED_ID | ||
| [HIS_BIRTH]ID | |||
| [HIS_DISCHARGE_TO]ID | [HIS_ENCOUNTER]DISCHARGE_ID | ||
| [HIS_DISEASE]ID | [HIS_ENCOUNTER_DISEASE]DISEASE_ID | ||
| [HIS_ENCOUNTER]ID | [HIS_ENCOUNTER_LOCATION]ENCOUNTER_ID [transact]encounter_id [HIS_PROCEDURE]ENCOUNTER_ID [HIS_BIRTH]encounter_id [HIS_ENCOUNTER_DISEASE]ENCOUNTER_ID [log]source_record_ID | ||
| [HIS_ENCOUNTER_DISEASE]ID | |||
| [HIS_ENCOUNTER_LOCATION]ID | [HIS_PROCEDURE]ENCOUNTER_LOCATION_ID | ||
| [HIS_PROCEDURE]ID | |||
| [HIS_WARD]ID | [HIS_BED]WARD_ID | ||
| [ID_changes]ID | |||
| [item]ID | [backorder]item_ID [item_store_join]item_ID [trans_line]item_ID [Goods_received_line]item_ID [item_line]item_ID [purchase_order_line]item_ID [item_direction]item_ID [item_warning_link]item_ID [quote_line]item_ID [log]source_record_ID [name_s_h_line]item_ID [item_note]item_ID [item_AMC_projection]item_id [list_name_join]item_ID [list_master_line]item_ID [asset_type]item_id [bom_master]ingredient_item_ID [Drug_register]Item_ID [item]cross_ref_item_ID [patient_medication]item_ID [tender_line]item_ID [bill_of_material]item_ID [HIS_PROCEDURE]ITEM_ID [Stock_take_lines]item_ID [bom_master]item_ID | ||
| [item_AMC_projection]ID | |||
| [item_category]ID | [item]category_ID | ||
| [item_category_level1]ID | [item_category_level2]parent_ID | ||
| [item_category_level2]ID | [item_category]parent_ID | ||
| [item_category2]ID | [item]category2_ID | ||
| [item_category3]ID | [item]category3_ID | ||
| [item_department]ID | [permission]item_dept_ID [item]department_ID | ||
| [item_direction]ID | |||
| [item_line]ID | [trans_line]item_line_ID [Stock_take_lines]item_line_ID [DOC_REFERENCE]LINKED_RECORD_ID [Item_line_note]IL_ID | ||
| [Item_line_note]ID | |||
| [item_note]ID | |||
| [item_store_join]ID | |||
| [item_warning_link]ID | |||
| [label]ID | |||
| [list_group]ID | [list_name_join]favourite_group_ID | ||
| [list_master]ID | [list_master_line]item_master_ID [list_group]master_group_ID | ||
| [list_master_line]ID | |||
| [list_name_join]ID | |||
| [Location]ID | [item_line]location_ID [item_store_join]default_location_ID [Goods_received_line]location_ID [trans_line]location_ID [Location_coordinate]Location_Id [purchase_order_line]location_ID [Stock_take_lines]location_id [item_store_join]location_bulk_ID [Location]parent_id | ||
| [Location_coordinate]ID | |||
| [Location_type]ID | [Location]type_ID [item_store_join]restricted_location_type_id | ||
| [log]ID | |||
| [name]ID | [name_budget]name_ID | ||
| [name]NEXT_OF_KIN_ID | |||
| [name_stock_history]name_ID | |||
| [transact]name_ID | |||
| [purchase_order]name_ID [item_line]name_ID [list_group]name_ID [quote_line]name_ID [name_note]name_ID [contact]name_ID [backorder]name_ID_customer [repeat_table]name_ID [backorder]name_ID_supplier [Drug_register]Supplier_ID [Drug_register]Manufacturer_ID [HIS_BIRTH]child_id [HIS_BIRTH]mother_id [HIS_ENCOUNTER]PATIENT_ID [list_name_join]name_ID [log]source_record_ID [patient_medication]name_ID [regimen_record]name_id [name_store_join]name_ID [Goods_received]donor_id [Goods_received_line]manufacturer_ID [item_line]manufacturer_ID [item_line]donor_id [asset]name_id [item_store_join]non_stock_name_ID [purchase_order_line]non_stock_name_ID [purchase_order_line]manufacturer_ID [name]mother_id [purchase_order]donor_id [quote_line]manufacturer_ID [quote]names_ID [store]name_ID [tender]BenchMarkSupplier_ID [trans_line]donor_id [trans_line]manufacturer_ID [transact]donor_default_id [item]non_stock_name_ID | |||
| [name_budget]ID | |||
| [name_category1]ID | [name]category1_ID | ||
| [name_category1_level1]ID | [name_category1_level2]parent_ID | ||
| [name_category1_level2]ID | [name_category1]parent_ID | ||
| [name_category2]ID | [name]category2_ID | ||
| [name_category3]ID | [name]category3_ID | ||
| [name_category4]ID | [name]category4_ID | ||
| [name_category5]ID | [name]category5_ID | ||
| [name_category6]ID | [name]category6_ID | ||
| [name_group]ID | [name]group_ID [permission]name_group_ID | ||
| [name_note]ID | |||
| [name_s_h_line]ID | |||
| [name_stock_history]ID | [name_s_h_line]name_s_h_ID [name_stock_history]previous_csh_id | ||
| [name_store_join]ID | |||
| [number]ID | |||
| [number_reuse]ID | |||
| [Occupation]ID | [name]occupation_ID | ||
| [patient_event]ID | [name_note]patient_event_ID | ||
| [patient_medication]ID | |||
| [period_amount]ID | |||
| [permission]ID | |||
| [pref]ID | |||
| [pref_blob]ID | |||
| [purchase_order]ID | [transact]original_PO_ID [purchase_order_line]purchase_order_ID [Goods_received]purchase_order_ID | ||
| [purchase_order_category]ID | [purchase_order]category_ID | ||
| [purchase_order_line]ID | [trans_line]order_lines_ID [Goods_received_line]order_line_ID [backorder]order_line_ID | ||
| [quote]ID | [quote_line]quote_ID [purchase_order]quote_ID [DOC_REFERENCE]LINKED_RECORD_ID | ||
| [quote_line]ID | [purchase_order_line]quote_line_ID | ||
| [regimen]ID | [regimen_line]regimen_id | ||
| [regimen_line]ID | |||
| [regimen_record]ID | [regimen_line]regimen_record_id | ||
| [Religion]ID | [name]religion_ID | ||
| [reminder]ID | |||
| [repeat_table]ID | [trans_line]repeat_ID | ||
| [report]ID | |||
| [Reports_By_User]ID | |||
| [ship_method]ID | [transact]ship_method_ID [HIS_ENCOUNTER]TRANSPORT_METHOD_ID | ||
| [sms_msg_processed]ID | |||
| [Stock_take]ID | [Stock_take_lines]stock_take_ID [log]source_record_ID | ||
| [Stock_take_lines]ID | |||
| [store]ID | [transact]store_ID [item_store_join]store_ID [name_store_join]store_ID [item_line]store_ID [user_store]store_ID [backorder]store_ID [Goods_received]store_ID [tender]store_ID [item_AMC_projection]store_id [Location]store_ID [log]store_ID [name_note]store_ID [name_stock_history]store_ID [name]supplying_store_id [pref_blob]store_id [purchase_order_line]store_ID [purchase_order]store_ID [regimen_record]store_id [Stock_take]store_ID | ||
| [sync_out]ID | [log]source_record_ID | ||
| [tender]ID | [tender_line]tender_ID [tender_condition]tender_ID [DOC_REFERENCE]LINKED_RECORD_ID [log]source_record_ID [quote]tender_ID | ||
| [tender_condition]ID | |||
| [Tender_condition_category]ID | [tender_condition]Condition_cat_id | ||
| [tender_line]ID | [quote_line]tender_line_ID | ||
| [trans_line]ID | [box_line]trans_line_ID [patient_medication]trans_line_ID [trans_line]supp_trans_line_ID_ns | ||
| [trans_note]ID | |||
| [transact]ID | [box]transactionID [bill_of_material]transaction_ID [trans_line]transaction_ID [log]source_record_ID [trans_note]transact_ID [Stock_take]invad_additions_ID [Stock_take]invad_reductions_ID [HIS_PROCEDURE]INVOICE_ID [backorder]customer_transaction_ID_ordere [backorder]customer_transaction_ID [name_stock_history]nsh_custInv_ID [transact]cust_transaction_id | ||
| [transaction_category]ID | [transact]category_ID | ||
| [unit]ID | [item]unit_ID [bill_of_material]unit_ID [bom_master]units_ID [tender_line]unit_ID | ||
| [user]ID | [user]group_ID [name_stock_history]user_ID [user_store]user_ID [transact]user_ID [store]responsible_user_ID [regimen_record]created_by [reminder]created_by_user_ID [reminder]user_ID [DOC_REFERENCE]USER_ID_FIRST_SAVED [DOC_REFERENCE]USER_ID_LAST_MODIFIED [Drug_register]created_by [Goods_received]user_id_modified [Goods_received]user_id_created [report]user_created_ID [purchase_order]created_by [purchase_order]last_edited_by [report]permission_ID [list_master]created_by_user_ID [item_note]created_by_user_ID [item_note]modified_by_user_ID [name_note]created_by_user_ID [name_note]modified_by_user_ID [patient_medication]user_created_ID [patient_medication]user_modified_ID [Stock_take]created_by_ID [Stock_take]finalised_by_ID [tender_condition]created_by_user_id [custom_data]created_by_user_ID [custom_data_category]entered_by_ID [Item_line_note]entered_by_ID [log]user_ID [pref_blob]user_ID [Reports_By_User]user_ID [tender]created_by_user_ID [transact]responsible_officer_ID | ||
| [user_store]ID | |||
| [warning]ID | [item_warning_link]warning_ID |
| Previous: 24.02. Other tables | | Next: 24.04. Internal tables |