-- 分次发货结构:上线前对目标库执行一次;历史已完成单据保留原流水,不自动推断发货批次。 CREATE TABLE mes_wm_product_sales_shipment ( id BIGINT NOT NULL AUTO_INCREMENT COMMENT '发货记录编号', sales_id BIGINT NOT NULL COMMENT '销售出库单编号', status TINYINT NOT NULL DEFAULT 0 COMMENT '0拣货中,10待运单,20待出库,30已出库,40已取消', carrier VARCHAR(100) DEFAULT NULL COMMENT '承运商', shipping_number VARCHAR(100) DEFAULT NULL COMMENT '运单号', outbound_time DATETIME DEFAULT NULL COMMENT '实际出库时间', outbound_user_id BIGINT DEFAULT 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), KEY idx_sales_status (sales_id, status, deleted) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='销售出库分次发货记录'; ALTER TABLE mes_wm_product_sales ADD COLUMN close_reason VARCHAR(500) DEFAULT NULL COMMENT '部分发货后关闭剩余数量的原因'; ALTER TABLE mes_wm_product_sales_detail ADD COLUMN shipment_id BIGINT DEFAULT NULL COMMENT '发货记录ID;历史明细为空', ADD KEY idx_shipment_id (shipment_id); ALTER TABLE mes_wm_transaction ADD COLUMN shipment_id BIGINT DEFAULT NULL COMMENT '销售发货记录ID;历史流水为空', ADD KEY idx_shipment_id (shipment_id);