crm/database/migrations/20230402133408_create_renovate_price_item_table.php

<?php
use think\migration\Migrator;
use think\migration\db\Column;
use app\model\CustomerPortraitField;

class CreateRenovatePriceItemTable extends Migrator
{

    public function change()
    {
        $this->table('renovate_price_item')
        ->addColumn('root_id', 'integer', ['comment'=>'企业id', 'limit'=>11, 'default'=>0])
        ->addColumn('pid', 'integer', ['comment'=>'所属套餐id', 'limit'=>11, 'default'=>0])
        ->addColumn('name', 'string', ['comment'=>'项目名称', 'limit'=>255, 'null'=>true])
        ->addColumn(Column::tinyInteger('rule')->setComment('计算规则(1单价*套内建筑面积,2单价*建筑面积,3单价*卧室数,4单价*卫生间数,5单价*厨房数,6固定价格)')->setDefault(0))
        ->addColumn(Column::decimal('price',10)->setComment('单价')->setDefault(0))
        ->addColumn(Column::tinyInteger('sort')->setComment('排序')->setDefault(0))
        ->create();
    }
}