From f4713534a4230f3acf7e7dc374b29edc30a5b451 Mon Sep 17 00:00:00 2001
From: tuqin <tuqin@tuqin.cn>
Date: 星期五, 23 十月 2026 09:46:10 +0800
Subject: [PATCH] docs(sql): 码鼎环保门禁(62.71)库结构补齐——11 张表缺列(审批/设备维护/供应商/开票/出入库等)

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

diff --git a/doc/sql/hbmjxt_mading_ddl_6271.sql b/doc/sql/hbmjxt_mading_ddl_6271.sql
new file mode 100644
index 0000000..3070a3a
--- /dev/null
+++ b/doc/sql/hbmjxt_mading_ddl_6271.sql
@@ -0,0 +1,99 @@
+-- 鐮侀紟鐜繚闂ㄧ绯荤粺锛�10.136.62.71锛夊簱缁撴瀯琛ラ綈琛ヤ竵
+-- 鐜拌薄1锛氭帴鍙� 404 鈥斺�� /environmentAccess/inspection/page銆�/environmentAccess/vehicle/page
+--        鍘熷洜锛氬悗绔� jar 涓烘棫鐗堬紝缂� com.ruoyi.envaccess 鏁翠釜鍖� 鈫� 鎹� ruoyi-mis.jar(4d26cab9鈥�) 瑙e喅
+-- 鐜拌薄2锛氭崲鍖呭悗鎶�
+--        java.sql.SQLSyntaxErrorException: Unknown column 'business_id' in 'field list'
+--        The error may exist in com/ruoyi/approve/mapper/ApproveProcessMapper.java
+--        鍘熷洜锛氬簱琛ㄧ粨鏋勮惤鍚庝簬瀹炰綋锛圡yBatis-Plus 鐢熸垚 SELECT 甯﹀嚭瀹炰綋鍏ㄩ儴鍒楋級
+-- 鎵ц搴擄細mis-ruoyi @10.136.62.71锛堝垪瀹氫箟鍙栬嚜鑺鐜繚 10.136.58.73 鍚屽悕搴擄級
+-- 鎵ц鏃堕棿锛�2026-10-23
+-- 鎵ц缁撴灉锛�11 寮犺〃鍏ㄩ儴琛ラ綈锛屼笌鏍囧噯搴� 0 宸紓
+
+-- 1. 瀹℃壒娴佺▼锛堟湰娆℃姤閿欐潵婧愶級
+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. 瀹℃壒鑺傜偣
+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. 瀹℃壒鏃ュ織
+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. 鍛樺伐涓汉鑱旂郴浜�
+ALTER TABLE staff_contacts_personal
+  ADD COLUMN user_id int NULL;
+
+-- 5. 鍞悗鏈嶅姟
+ALTER TABLE after_sales_service
+  ADD COLUMN status_name varchar(255) NULL;
+
+-- 6. 璁惧缁存姢
+ALTER TABLE device_maintenance
+  ADD COLUMN maintenance_cycle varchar(255) NULL,
+  ADD COLUMN maintenance_content varchar(1000) NULL;
+
+-- 7. 閲囪喘鍑哄簱
+ALTER TABLE procurement_record_out
+  ADD COLUMN supplier_name varchar(255) NULL,
+  ADD COLUMN type int NULL,
+  ADD COLUMN requisition_num decimal(18,2) NULL;
+
+-- 8. 閲囪喘鍏ュ簱
+ALTER TABLE procurement_record_storage
+  ADD COLUMN min_stock decimal(18,2) NULL,
+  ADD COLUMN total_price decimal(18,2) NULL,
+  ADD COLUMN unit_price decimal(18,2) NULL,
+  ADD COLUMN registrant varchar(255) NULL;
+
+-- 9. 閿�鍞彴璐︽帓浜�
+ALTER TABLE sales_ledger_scheduling
+  ADD COLUMN completion_deadline date NULL,
+  ADD COLUMN production_requirement varchar(255) NULL;
+
+-- 10. 渚涘簲鍟嗙鐞�
+ALTER TABLE supplier_manage
+  ADD COLUMN supplier_code varchar(255) NULL,
+  ADD COLUMN supplier_short_name varchar(255) NULL,
+  ADD COLUMN supplier_category varchar(255) NULL,
+  ADD COLUMN supplier_level varchar(255) NULL,
+  ADD COLUMN qualification_status int NULL,
+  ADD COLUMN qualification_expiry_date date NULL,
+  ADD COLUMN cooperation_status int NULL,
+  ADD COLUMN cooperation_start_date date NULL,
+  ADD COLUMN cooperation_history_summary varchar(1000) NULL,
+  ADD COLUMN supplied_products_summary varchar(1000) NULL,
+  ADD COLUMN remark varchar(1000) NULL,
+  ADD COLUMN delete_flag int NULL;
+
+-- 11. 寮�绁ㄧ櫥璁�
+ALTER TABLE ticket_registration
+  ADD COLUMN invoice_code varchar(255) NULL,
+  ADD COLUMN invoice_type varchar(255) NULL,
+  ADD COLUMN invoice_status int NULL,
+  ADD COLUMN tax_rate decimal(18,2) NULL,
+  ADD COLUMN tax_amount decimal(18,2) NULL,
+  ADD COLUMN currency varchar(255) NULL,
+  ADD COLUMN supplier_id bigint NULL,
+  ADD COLUMN sales_contract_no_id bigint NULL,
+  ADD COLUMN verification_status int NULL,
+  ADD COLUMN file_name varchar(1000) NULL,
+  ADD COLUMN remark varchar(1000) NULL,
+  ADD COLUMN delete_flag int NULL,
+  ADD COLUMN create_user bigint NULL,
+  ADD COLUMN update_user bigint NULL,
+  ADD COLUMN update_time datetime NULL;

--
Gitblit v1.9.3