tables_fields:foreign_keys

24.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



  • Last modified: 2021/10/08 11:08
  • by Gary Willetts