-- 出厂检验添加发货信息关联字段
-- 执行时间：2026-06-23

ALTER TABLE quality_inspect
    ADD COLUMN shipping_info_id BIGINT DEFAULT NULL COMMENT '发货信息id（出厂检验关联发货）' AFTER sales_ledger_id;

-- 添加索引优化查询
CREATE INDEX idx_quality_inspect_shipping_info ON quality_inspect(shipping_info_id, product_model_id);