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 |
Previous: 24.02. Other tables | | Next: 24.04. Internal tables |