shipping-template/database/migrations/20251010100100_create_shipping_template_rules_table.php

<?php

class CreateShippingTemplateRulesTable extends \Phinx\Migration\AbstractMigration
{
    public function change()
    {
        $table = $this->table('shipping_template_rules');
        $table->setId('id')
            ->addColumn('template_id', 'integer', ['comment' => '运费模板ID'])
            ->addColumn('first', 'decimal', ['precision' => 10, 'scale' => 3, 'comment' => '首件/首重/首体积'])
            ->addColumn('first_price', 'decimal', ['precision' => 10, 'scale' => 2, 'comment' => '首件/首重/首体积费用'])
            ->addColumn('next_price', 'decimal', ['precision' => 10, 'scale' => 2, 'comment' => '续件/续重/续体积费用'])
            ->addColumn('area_type', 'string', ['limit' => 20, 'comment' => '区域类型: default(默认), special(特殊区域)'])
            ->addColumn('sort', 'integer', ['comment' => '排序', 'default' => 100])
            ->addColumn('regions', 'json', ['comment' => '地区信息(JSON格式，省级行政区划，包含地区编码和名称)', 'null' => true])
            ->addTimestamps('create_time', 'update_time')
            ->addIndex(['template_id'])
            ->addIndex(['area_type'])
            ->create();
    }
}