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 | 8 ++++++++
1 files changed, 8 insertions(+), 0 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 203b99a..f88c563 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -244,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,
@@ -278,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,
@@ -345,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,
@@ -369,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,
@@ -394,6 +400,7 @@
"source_doc_id" bigint DEFAULT NULL,
"source_line_id" bigint DEFAULT NULL,
"source_doc_code" varchar(64) DEFAULT NULL,
+ "reel_no" varchar(128) DEFAULT NULL,
"client_id" bigint DEFAULT NULL,
"batch_code" varchar(64) DEFAULT NULL,
"item_id" bigint NOT NULL,
@@ -678,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