-- 采购申请对齐采购台账字段：新增/编辑申请单要与新增采购台账字段一致
-- 执行库：product-inventory-management（各租户库同）
ALTER TABLE `purchase_application`
    ADD COLUMN `purchase_contract_number` varchar(50)  DEFAULT NULL COMMENT '采购合同号' AFTER `convert_time`,
    ADD COLUMN `recorder_id`              bigint       DEFAULT NULL COMMENT '录入人id' AFTER `purchase_contract_number`,
    ADD COLUMN `entry_date`               date         DEFAULT NULL COMMENT '录入日期' AFTER `recorder_id`,
    ADD COLUMN `execution_date`           date         DEFAULT NULL COMMENT '签订日期' AFTER `entry_date`,
    ADD COLUMN `best_arrival_date`        date         DEFAULT NULL COMMENT '最佳到站日期' AFTER `execution_date`,
    ADD COLUMN `application_submit_time`  datetime     DEFAULT NULL COMMENT '申请提交时间' AFTER `best_arrival_date`,
    ADD COLUMN `purchase_category`        varchar(50)  DEFAULT NULL COMMENT '采购类别：客存、代储、采购入库、采购直销' AFTER `application_submit_time`,
    ADD COLUMN `logistics_method`         varchar(50)  DEFAULT NULL COMMENT '物流方式：厂家配送、委外物流、客户自提' AFTER `purchase_category`,
    ADD COLUMN `pickup_method`            varchar(50)  DEFAULT NULL COMMENT '提货方式：暂不提货、提货' AFTER `logistics_method`,
    ADD COLUMN `oil_depot_id`             bigint       DEFAULT NULL COMMENT '采购油库id' AFTER `pickup_method`,
    ADD COLUMN `customer_name`            varchar(100) DEFAULT NULL COMMENT '客户名称' AFTER `oil_depot_id`,
    ADD COLUMN `purchase_quantity`        int          DEFAULT NULL COMMENT '采购数量（吨）' AFTER `customer_name`,
    ADD COLUMN `purchase_order_status`    varchar(50)  DEFAULT NULL COMMENT '采购申请订单状态' AFTER `purchase_quantity`;

-- 采购申请产品明细新增预警数量（与采购台账明细 warn_num 对齐）
ALTER TABLE `purchase_application_product`
    ADD COLUMN `warn_num` decimal(10, 2) DEFAULT NULL COMMENT '预警数量' AFTER `quantity`;