Files
MES/yawei-mes/.sql/2025-12-09_v1.0.40_周启威_生产计划添加来源字段.sql
2026-04-02 10:39:03 +08:00

4 lines
383 B
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

-- 生产计划表添加来源关联字段
ALTER TABLE `pro_plan` ADD COLUMN `plan_source_type` varchar(20) DEFAULT NULL COMMENT '来源类型order=销售订单, plan=销售计划';
ALTER TABLE `pro_plan` ADD COLUMN `plan_source_id` bigint(20) DEFAULT NULL COMMENT '来源ID';
ALTER TABLE `pro_plan` ADD COLUMN `plan_source_number` varchar(64) DEFAULT NULL COMMENT '来源编号';