From ffca46b39d25439a06a27cafda2ec523a3fb67cf Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期二, 27 十月 2026 17:53:02 +0800
Subject: [PATCH] feat(mes): 增加盘号字段支持和优化报工质检流程

---
 yudao-module-mes/src/test/resources/sql/create_tables.sql |   11 ++++++++++-
 1 files changed, 10 insertions(+), 1 deletions(-)

diff --git a/yudao-module-mes/src/test/resources/sql/create_tables.sql b/yudao-module-mes/src/test/resources/sql/create_tables.sql
index 780ff99..f88c563 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -202,6 +202,7 @@
     "source_line_id" bigint DEFAULT NULL,
     "source_doc_code" varchar(64) DEFAULT NULL,
     "vendor_id" bigint DEFAULT NULL,
+    "vendor_name" varchar(255) DEFAULT NULL,
     "vendor_batch" varchar(64) DEFAULT NULL,
     "item_id" bigint DEFAULT NULL,
     "received_quantity" decimal(24,6) DEFAULT NULL,
@@ -243,6 +244,7 @@
     "source_line_id" bigint DEFAULT NULL,
     "source_doc_code" varchar(64) DEFAULT NULL,
     "work_order_id" bigint DEFAULT NULL,
+    "reel_no" varchar(128) DEFAULT NULL,
     "task_id" bigint DEFAULT NULL,
     "workstation_id" bigint DEFAULT NULL,
     "process_id" bigint DEFAULT NULL,
@@ -277,6 +279,9 @@
 -- MES 鐢熶骇鎶ュ伐
 -- ----------------------------
 CREATE TABLE IF NOT EXISTS "mes_pro_feedback" (
+    "machinery_ids" varchar(2048) DEFAULT NULL,
+    "process_instance_id" varchar(64) DEFAULT NULL,
+    "process_definition_key" varchar(255) DEFAULT NULL,
     "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
     "code" varchar(64) DEFAULT NULL,
     "type" tinyint DEFAULT NULL,
@@ -344,6 +349,7 @@
     "quantity" decimal(12,2) DEFAULT NULL,
     "batch_id" bigint DEFAULT NULL,
     "batch_code" varchar(255) DEFAULT NULL,
+    "reel_no" varchar(128) DEFAULT NULL,
     "expire_date" timestamp DEFAULT NULL,
     "lot_number" varchar(128) DEFAULT NULL,
     "quality_status" int DEFAULT NULL,
@@ -368,6 +374,7 @@
     "quantity" decimal(12,2) DEFAULT NULL,
     "batch_id" bigint DEFAULT NULL,
     "batch_code" varchar(255) DEFAULT NULL,
+    "reel_no" varchar(128) DEFAULT NULL,
     "warehouse_id" bigint DEFAULT NULL,
     "location_id" bigint DEFAULT NULL,
     "area_id" bigint DEFAULT NULL,
@@ -393,7 +400,8 @@
     "source_doc_id" bigint DEFAULT NULL,
     "source_line_id" bigint DEFAULT NULL,
     "source_doc_code" varchar(64) DEFAULT NULL,
-    "client_id" bigint NOT NULL,
+    "reel_no" varchar(128) DEFAULT NULL,
+    "client_id" bigint DEFAULT NULL,
     "batch_code" varchar(64) DEFAULT NULL,
     "item_id" bigint NOT NULL,
     "min_check_quantity" int DEFAULT 1,
@@ -677,6 +685,7 @@
     "id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
     "code" varchar(128) DEFAULT NULL,
     "item_id" bigint DEFAULT NULL,
+    "reel_no" varchar(128) DEFAULT NULL,
     "produce_date" timestamp DEFAULT NULL,
     "expire_date" timestamp DEFAULT NULL,
     "receipt_date" timestamp DEFAULT NULL,

--
Gitblit v1.9.3