baoshi-was/database/migrations/2021_12_22_153152_create_receiving_tasks_table.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateReceivingTasksTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('receiving_tasks', function (Blueprint $table) {
            $table->id();
            $table->String('number')->unique()->comment('收货任务清单');
            $table->integer('warehouse_id')->index()->comment('仓库');
            $table->integer('owner_id')->index()->comment('货主');
            $table->String("for_single_member")->comment('投单员');
            $table->integer('delivery_appointment_car_id')->unique()->comment('预约号');

            $table->String('driver_name')->comment('司机姓名');
            $table->String('driver_phone')->comment('司机号码');

            $table->String('plate_number')->comment('车牌号');
            $table->String('driving_license_no')->comment('驾驶证号');
            $table->String('logistics_single_number')->comment('物流单号');

            $table->enum('provide_list',['是','否'])->comment("是否提供清单");
            $table->enum('receiving_type',['正常','盲收'])->comment("收货类型");
            $table->enum('status',['创建','进行中','完成','超时完成'])->comment('状态');

            $table->dateTime('end_at')->comment('完结时间');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('receiving_tasks');
    }
}