From 5072520172e8f45e3ccb8afc26cf0c8186ba4cdd Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 19 十月 2026 16:31:42 +0800
Subject: [PATCH] refactor(mes): 重构质量管理和批次绑定功能
---
yudao-module-mes/src/test/resources/sql/create_tables.sql | 22 ++++++++++++++--------
1 files changed, 14 insertions(+), 8 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 1e8d1c7..53cdbba 100644
--- a/yudao-module-mes/src/test/resources/sql/create_tables.sql
+++ b/yudao-module-mes/src/test/resources/sql/create_tables.sql
@@ -413,7 +413,6 @@
"inspect_date" timestamp DEFAULT NULL,
"inspector_user_id" bigint DEFAULT NULL,
"status" tinyint NOT NULL DEFAULT 0,
- "workflow_status" tinyint NOT NULL DEFAULT 0,
"remark" varchar(500) DEFAULT '',
"creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
@@ -424,15 +423,22 @@
PRIMARY KEY ("id")
);
-CREATE TABLE IF NOT EXISTS "mes_qc_oqc_action" (
+-- ----------------------------
+-- MES 璐ㄦ瀹℃牳浜洪厤缃�
+-- ----------------------------
+CREATE TABLE IF NOT EXISTS "mes_qc_approver_config" (
"id" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY,
- "oqc_id" bigint NOT NULL,
- "action" varchar(32) NOT NULL,
- "result" tinyint DEFAULT NULL,
- "opinion" varchar(500) DEFAULT NULL,
- "quantities_json" varchar(4000) DEFAULT NULL,
- "operator_id" bigint DEFAULT NULL,
+ "qc_type" tinyint NOT NULL,
+ "approve_node" tinyint NOT NULL,
+ "user_id" bigint NOT NULL,
+ "status" tinyint NOT NULL DEFAULT 0,
+ "remark" varchar(255) DEFAULT NULL,
+ "creator" varchar(64) DEFAULT '',
"create_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "updater" varchar(64) DEFAULT '',
+ "update_time" timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
+ "deleted" bit NOT NULL DEFAULT FALSE,
+ "tenant_id" bigint NOT NULL DEFAULT 0,
PRIMARY KEY ("id")
);
--
Gitblit v1.9.3