20.03. Foreign keys

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: 20.02. Other tables | | Next: 20.04. Internal tables