-- 出库流通管理：销售出库与袋码/托盘码关联（无租户字段）
|
-- 执行前请确认目标数据库为 mom-thzy，并逐条执行。
|
|
ALTER TABLE mes_wm_product_sales_detail
|
ADD COLUMN bag_code_id bigint DEFAULT NULL COMMENT '袋码编号' AFTER area_id;
|
ALTER TABLE mes_wm_product_sales_detail
|
ADD COLUMN pallet_code_id bigint DEFAULT NULL COMMENT '托盘码编号' AFTER bag_code_id;
|
ALTER TABLE mes_wm_product_sales_detail
|
ADD INDEX idx_sales_detail_bag_code (bag_code_id);
|
ALTER TABLE mes_wm_product_sales_detail
|
ADD INDEX idx_sales_detail_pallet_code (pallet_code_id);
|
|
ALTER TABLE mes_pro_bag_code
|
ADD COLUMN sales_id bigint DEFAULT NULL COMMENT '最近销售出库单编号' AFTER inbound_line_code;
|
ALTER TABLE mes_pro_bag_code
|
ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '最近销售出库时间' AFTER sales_id;
|
ALTER TABLE mes_pro_bag_code
|
ADD INDEX idx_bag_code_sales (sales_id);
|
|
ALTER TABLE mes_pro_pallet
|
ADD COLUMN sales_id bigint DEFAULT NULL COMMENT '最近销售出库单编号' AFTER status;
|
ALTER TABLE mes_pro_pallet
|
ADD COLUMN outbound_time datetime DEFAULT NULL COMMENT '最近销售出库时间' AFTER sales_id;
|
ALTER TABLE mes_pro_pallet
|
ADD INDEX idx_pallet_sales (sales_id);
|
