From 4ca4444ad33a2a1a51f5c06e78ee9365dfb1eed6 Mon Sep 17 00:00:00 2001 From: liu <2021943741@qq.com> Date: 星期四, 08 十月 2026 17:11:11 +0800 Subject: [PATCH] feat(mes): 种子二维码标签国标四要素合规改造 --- sql/mysql/mes_wm_material_stock_bag.sql | 31 +++++++++++++++++++++++++++++++ 1 files changed, 31 insertions(+), 0 deletions(-) diff --git a/sql/mysql/mes_wm_material_stock_bag.sql b/sql/mysql/mes_wm_material_stock_bag.sql new file mode 100644 index 0000000..e659a95 --- /dev/null +++ b/sql/mysql/mes_wm_material_stock_bag.sql @@ -0,0 +1,31 @@ +CREATE TABLE mes_wm_material_stock_bag ( + id BIGINT NOT NULL AUTO_INCREMENT COMMENT '缂栧彿', + material_stock_id BIGINT NOT NULL COMMENT '搴撳瓨姹囨�昏褰旾D', + bag_code_id BIGINT NOT NULL COMMENT '鐢熶骇琚嬬爜ID', + bag_code VARCHAR(64) NOT NULL COMMENT '琚嬬爜', + item_id BIGINT NOT NULL COMMENT '鐗╂枡ID', + batch_id BIGINT NULL COMMENT '浠撳簱鎵规ID', + batch_code VARCHAR(64) NULL COMMENT '鎵规鍙�', + vendor_id BIGINT NULL COMMENT '渚涘簲鍟咺D', + warehouse_id BIGINT NOT NULL COMMENT '浠撳簱ID', + location_id BIGINT NULL COMMENT '搴撳尯ID', + area_id BIGINT NULL COMMENT '搴撲綅ID', + stock_state TINYINT NOT NULL COMMENT '搴撳瓨鐘舵�侊細10鏆傚瓨锛�20鍚堟牸锛�30宸插嚭搴擄紝40鎶ュ簾', + status TINYINT NOT NULL DEFAULT 1 COMMENT '鏄庣粏鐘舵�侊細1鍦ㄥ簱锛�2宸插嚭搴擄紝3宸叉姤搴�', + quantity DECIMAL(18, 6) NOT NULL DEFAULT 1 COMMENT '琚嬬爜搴撳瓨鏁伴噺', + frozen BIT NOT NULL DEFAULT 0 COMMENT '鏄惁鍐荤粨', + last_transaction_id BIGINT NULL COMMENT '鏈�杩戝簱瀛樹簨鍔D', + inbound_time DATETIME NULL COMMENT '鍏ュ簱鏃堕棿', + outbound_time DATETIME NULL COMMENT '鍑哄簱鏃堕棿', + creator VARCHAR(64) DEFAULT '' COMMENT '鍒涘缓鑰�', + create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + updater VARCHAR(64) DEFAULT '' COMMENT '鏇存柊鑰�', + update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + deleted BIT NOT NULL DEFAULT 0 COMMENT '鏄惁鍒犻櫎', + PRIMARY KEY (id), + UNIQUE KEY uk_bag_code (bag_code), + KEY idx_material_stock (material_stock_id), + KEY idx_batch_state (batch_id, stock_state, status), + KEY idx_location_state (warehouse_id, location_id, area_id, stock_state, status), + KEY idx_bag_code_id (bag_code_id) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='MES搴撳瓨琚嬬爜鏄庣粏'; -- Gitblit v1.9.3