From 94652b486a9f4ee8958e37e6681a83c1e1ceef1f Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 23 十月 2026 09:17:42 +0800
Subject: [PATCH] docs(sql): 码鼎人力(62.70)审批模块缺列补丁——approve_process/approve_node/approve_log/staff_contacts_personal

---
 doc/sql/rlzyxt_approve_ddl.sql |   52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 52 insertions(+), 0 deletions(-)

diff --git a/doc/sql/rlzyxt_approve_ddl.sql b/doc/sql/rlzyxt_approve_ddl.sql
new file mode 100644
index 0000000..c443719
--- /dev/null
+++ b/doc/sql/rlzyxt_approve_ddl.sql
@@ -0,0 +1,52 @@
+-- 鐮侀紟浜哄姏璧勬簮绯荤粺锛�10.136.62.70锛夊鎵规ā鍧楃己鍒楄ˉ涓�
+-- 鐜拌薄锛氳繘鍏ュ鎵圭浉鍏抽〉闈㈡姤
+--   java.sql.SQLSyntaxErrorException: Unknown column 'business_id' in 'field list'
+--   The error may exist in com/ruoyi/approve/mapper/ApproveProcessMapper.java
+-- 鍘熷洜锛歞ev_tide 鍒嗘敮瀹炰綋锛坈om.ruoyi.approve.pojo.ApproveProcess / ApproveNode / ApproveLog锛�
+--       宸叉湁浠ヤ笅瀛楁锛屼絾绾夸笂搴撹〃缁撴瀯钀藉悗锛堢己鍒楋級銆侻yBatis-Plus 鐢熸垚 SELECT 鏃跺甫鍑哄叏閮ㄥ疄浣撳垪锛�
+--       搴撶己鍒楀嵆鎶� Unknown column銆�
+-- 鎵ц搴擄細mis-ruoyi @10.136.62.70锛堝垪瀹氫箟鍙栬嚜鑺 10.136.58.66 鐨勫悓鍚嶅簱锛�
+-- 鎵ц鏃堕棿锛�2026-10-23
+
+-- 1. approve_process 缂� 7 鍒�
+ALTER TABLE approve_process
+  ADD COLUMN business_id bigint NULL COMMENT '涓氬姟id',
+  ADD COLUMN business_no varchar(255) NULL COMMENT '涓氬姟缂栧彿',
+  ADD COLUMN business_title varchar(255) NULL COMMENT '涓氬姟鏍囬',
+  ADD COLUMN amount decimal(18,2) NULL COMMENT '閲戦',
+  ADD COLUMN business_data text NULL COMMENT '涓氬姟鏁版嵁',
+  ADD COLUMN flow_definition_id bigint NULL COMMENT '娴佺▼瀹氫箟id',
+  ADD COLUMN update_time datetime NULL COMMENT '鏇存柊鏃堕棿';
+
+-- 2. approve_node 缂� 5 鍒�
+ALTER TABLE approve_node
+  ADD COLUMN approve_node_name varchar(255) NULL,
+  ADD COLUMN condition_field varchar(255) NULL,
+  ADD COLUMN condition_operator varchar(255) NULL,
+  ADD COLUMN condition_value varchar(1000) NULL,
+  ADD COLUMN is_current int NULL;
+
+-- 3. approve_log 缂� 4 鍒�
+ALTER TABLE approve_log
+  ADD COLUMN approve_node_id bigint NULL,
+  ADD COLUMN approve_process_id bigint NULL,
+  ADD COLUMN approve_user_name varchar(255) NULL,
+  ADD COLUMN tenant_id bigint NULL;
+
+-- 4. staff_contacts_personal 缂� 1 鍒楋紙浜哄姏璧勬簮-鍛樺伐涓汉鑱旂郴浜猴級
+ALTER TABLE staff_contacts_personal
+  ADD COLUMN user_id int NULL;
+
+-- 璇存槑锛氬悓搴撹繕鏈変互涓嬭〃鐩稿鏍囧噯搴撶己鍒楋紝灞炲叾瀹冧笟鍔℃ā鍧楋紙渚涘簲鍟�/鍙戠エ/鍞悗/璁惧缁存姢/鍑哄叆搴擄級锛�
+--      浜哄姏璧勬簮绯荤粺褰撳墠鏈敤鍒帮紝闇�瑕佹椂鍐嶈ˉ锛�
+--   after_sales_service      : status_name
+--   device_maintenance       : maintenance_cycle, maintenance_content
+--   procurement_record_out   : supplier_name, type
+--   procurement_record_storage : min_stock, total_price, unit_price
+--   supplier_manage          : cooperation_history_summary, cooperation_start_date, cooperation_status,
+--                              delete_flag, qualification_expiry_date, qualification_status, remark,
+--                              supplied_products_summary, supplier_category, supplier_code,
+--                              supplier_level, supplier_short_name
+--   ticket_registration      : create_user, currency, delete_flag, file_name, invoice_code,
+--                              invoice_status, invoice_type, remark, sales_contract_no_id, supplier_id,
+--                              tax_amount, tax_rate, update_time, update_user, verification_status

--
Gitblit v1.9.3