From 704265308b1227dbada5a36b2027b588c062ded2 Mon Sep 17 00:00:00 2001
From: 云 <2163098428@qq.com>
Date: 星期一, 12 十月 2026 09:14:37 +0800
Subject: [PATCH] feat(mes): 新增业务码支持并优化追溯查询功能
---
sql/mysql/mes_pro_batch_bag_code_init.sql | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/sql/mysql/mes_pro_batch_bag_code_init.sql b/sql/mysql/mes_pro_batch_bag_code_init.sql
index ed7fc6c..16da06f 100644
--- a/sql/mysql/mes_pro_batch_bag_code_init.sql
+++ b/sql/mysql/mes_pro_batch_bag_code_init.sql
@@ -13,6 +13,7 @@
CREATE TABLE IF NOT EXISTS `mes_pro_batch` (
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
`code` VARCHAR(64) DEFAULT NULL COMMENT '鎵规鍙凤紙琛ュ綍涓氬姟淇℃伅鍚庤嚜鍔ㄧ敓鎴愶紱鍗曟褰曞叆鎴栬ˉ褰曟祦绋嬪繀濉級',
+ `business_code` VARCHAR(16) DEFAULT NULL COMMENT '鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級',
`temp_code` VARCHAR(64) DEFAULT NULL COMMENT '涓存椂鎵规鐮侊紙PB-8浣嶅叏灞�搴忓彿锛岄鐢熸垚浜岀淮鐮侀樁娈典娇鐢級',
`item_id` BIGINT NOT NULL COMMENT '鍝佺锛堜骇鍝佺墿鏂欙級缂栧彿锛屽叧鑱� mdm_item.id',
`line_id` BIGINT DEFAULT NULL COMMENT '浜х嚎缂栧彿锛屽叧鑱� mes_pro_line.id',
@@ -39,6 +40,7 @@
`deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_code` (`code`),
+ UNIQUE KEY `uk_business_code` (`business_code`),
UNIQUE KEY `uk_temp_code` (`temp_code`),
KEY `idx_item_id` (`item_id`),
KEY `idx_work_order_id` (`work_order_id`),
@@ -70,7 +72,9 @@
CREATE TABLE IF NOT EXISTS `mes_pro_pallet` (
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
`code` VARCHAR(64) DEFAULT NULL COMMENT '鎵樼洏鐮侊紙鎵规鍙�-P+鎵樼洏搴忓彿锛岀粦瀹氭壒娆″悗鐢熸垚锛�',
+ `business_code` VARCHAR(16) DEFAULT NULL COMMENT '鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級',
`temp_code` VARCHAR(64) DEFAULT NULL COMMENT '涓存椂鎵樼洏鐮侊紙PL-8浣嶅叏灞�搴忓彿锛岄鐢熸垚浜岀淮鐮侀樁娈典娇鐢級',
+ `item_id` BIGINT DEFAULT NULL COMMENT '鎵樼洏鍝佺缂栧彿',
`batch_id` BIGINT DEFAULT NULL COMMENT '鐢熶骇鎵规缂栧彿锛岀粦瀹氭壒娆″悗鍏宠仈 mes_pro_batch.id',
`batch_code` VARCHAR(64) DEFAULT NULL COMMENT '鎵规鍙凤紙鍐椾綑锛屼究浜庡睍绀猴級',
`pallet_no` INT DEFAULT NULL COMMENT '鎵规鍐呮墭鐩樺簭鍙凤紙缁戝畾鎵规鍚庣敓鎴愶級',
@@ -86,6 +90,7 @@
`deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_code` (`code`),
+ UNIQUE KEY `uk_business_code` (`business_code`),
UNIQUE KEY `uk_temp_code` (`temp_code`),
KEY `idx_batch_id` (`batch_id`)
) ENGINE = InnoDB COMMENT = 'MES 鎵樼洏鐮�';
@@ -97,6 +102,7 @@
`id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿',
`uuid` VARCHAR(32) DEFAULT NULL COMMENT '鐢熸垚缁� UUID锛堟爣璁板悓涓�娆＄敓鎴愮殑鏁版嵁鍖咃級',
`code` VARCHAR(64) NOT NULL COMMENT '琚嬬爜锛堜簩缁寸爜鍐呭锛屽叏灞�鍞竴锛�',
+ `business_code` VARCHAR(16) DEFAULT NULL COMMENT '鍐呴儴鍑哄叆搴撲笟鍔＄爜锛�16浣嶆暟瀛楋級',
`bag_no` INT NOT NULL COMMENT '鍏ㄥ眬琚嬪簭鍙�',
`batch_id` BIGINT DEFAULT NULL COMMENT '鐢熶骇鎵规缂栧彿锛屽綍鍏ヤ俊鎭悗鍏宠仈 mes_pro_batch.id',
`batch_code` VARCHAR(64) DEFAULT NULL COMMENT '鎵规鍙凤紙鍐椾綑锛屼究浜庡睍绀猴級',
@@ -115,6 +121,7 @@
`deleted` BIT(1) NOT NULL DEFAULT b'0' COMMENT '鏄惁鍒犻櫎',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_code` (`code`),
+ UNIQUE KEY `uk_business_code` (`business_code`),
KEY `idx_batch_id` (`batch_id`),
KEY `idx_uuid` (`uuid`),
KEY `idx_pallet_id` (`pallet_id`)
--
Gitblit v1.9.3