anonymous//database/migrations/2024_07_26_173507_create_regions_table.php$0

Complexity

Total Complexity

2

Size/Duplication

Total Lines	31
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	2024_07_26_173507_create_regions_table.php$0 ➔ down()	0	3	1
A	2024_07_26_173507_create_regions_table.php$0 ➔ up()	0	17	1

<?php

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

return new class extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('regions', function (Blueprint $table) {
            $table->id();
            $table->string('name')->comment('社区名称');
            $table->string('city_code')->comment("城市代码");
            $table->string('city')->comment("城市名称");
            $table->string('province_code')->comment("省份名称");
            $table->string('province')->comment("省份名称");
            $table->string('county_code')->comment("县区名称");
            $table->string('county')->comment("县区名称");
            $table->string('address')->comment("地址");
            $table->geography('geo', subtype: 'point')->comment("地理信息");
            $table->string('model_id')->index()->nullable()->comment("模型ID");
            $table->string('model_type')->index()->nullable()->comment('关联类');
            $table->timestamps();
            $table->comment("地理信息储存表");
        });
    }

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