From beaba1bf3a30053408a860479f9150b02169a7c8 Mon Sep 17 00:00:00 2001 From: 云 <2163098428@qq.com> Date: 星期一, 24 八月 2026 17:04:16 +0800 Subject: [PATCH] feat(mes): 添加种子质检功能模块 --- sql/mes_scan_event_inbound.sql | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/sql/mes_scan_event_inbound.sql b/sql/mes_scan_event_inbound.sql new file mode 100644 index 0000000..c521d1a --- /dev/null +++ b/sql/mes_scan_event_inbound.sql @@ -0,0 +1,36 @@ +ALTER TABLE mes_pro_bag_code ADD COLUMN inbound_time datetime NULL COMMENT '鍏ュ簱鏃堕棿'; +ALTER TABLE mes_pro_bag_code ADD COLUMN inbound_event_id bigint NULL COMMENT '鍏ュ簱浜嬩欢ID'; +ALTER TABLE mes_pro_bag_code ADD COLUMN inbound_device_code varchar(64) NULL COMMENT '鍏ュ簱璁惧缂栫爜'; +ALTER TABLE mes_pro_bag_code ADD COLUMN inbound_line_code varchar(64) NULL COMMENT '鍏ュ簱浜х嚎缂栫爜'; +ALTER TABLE mes_pro_batch ADD COLUMN inbound_bag_quantity int NULL DEFAULT 0 COMMENT '绱鍏ュ簱琚嬫暟' AFTER pallet_quantity; + +ALTER TABLE mes_pro_batch ADD COLUMN inbound_event_id bigint NULL COMMENT '鍏ュ簱浜嬩欢ID'; +ALTER TABLE mes_pro_batch ADD COLUMN inbound_device_code varchar(64) NULL COMMENT '鍏ュ簱璁惧缂栫爜'; +ALTER TABLE mes_pro_batch ADD COLUMN inbound_line_code varchar(64) NULL COMMENT '鍏ュ簱浜х嚎缂栫爜'; +CREATE TABLE mes_pro_scan_event ( + id bigint NOT NULL AUTO_INCREMENT, + event_id varchar(64) NOT NULL, + bag_code varchar(128) NOT NULL, + bag_code_id bigint NULL, + batch_id bigint NULL, + batch_code varchar(128) NULL, + item_id bigint NULL, + quantity decimal(18,6) NULL, + device_code varchar(64) NOT NULL, + line_code varchar(64) NULL, + warehouse_id bigint NULL, + location_id bigint NULL, + area_id bigint NULL, + transaction_id bigint NULL, + status varchar(16) NOT NULL DEFAULT 'FAILED', + error_code varchar(64) NULL, + error_message varchar(500) NULL, + received_time datetime NOT NULL, + failed_time datetime NULL, + event_time datetime NULL, + remark varchar(500) NULL, + creator varchar(64) NULL, create_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, + updater varchar(64) NULL, update_time datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + deleted bit NOT NULL DEFAULT 0, + PRIMARY KEY (id), UNIQUE KEY uk_mes_scan_event_event_id (event_id), UNIQUE KEY uk_mes_scan_event_bag (bag_code_id), KEY idx_mes_scan_event_status (status), KEY idx_mes_scan_event_error_code (error_code), KEY idx_mes_scan_event_received_time (received_time) +) ENGINE=InnoDB COMMENT='MES琚嬬爜鎵爜鍏ュ簱浜嬩欢'; -- Gitblit v1.9.3