I'm facing problem when add foreign key and doing php artisan migrate : fresh

There is error

("SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'id_rso'")

This is my migration table :

public function up()
    {   
        Schema::enableForeignKeyConstraints();
        Schema::create('dso', function (Blueprint $table) {
            $table->string('id_dso',30);
            $table->unsignedBigInteger('id_rso');
            $table->foreignId('id_rso')->constrained('rso');
            $table->smallInteger('id_focus');
            $table->smallInteger('id_wilayah');
            $table->smallInteger('id_grup_wilayah');
            $table->string('nama_dso',50);
            $table->string('created_by',50)->nullable();
            $table->timestamp('created_date',$precision = 0);
            $table->string('modified_by',50)->nullable();
            $table->timestamp('modified_date',$precision = 0)->nullable()->default(null);
            $table->boolean('status')->default(true);
            $table->timestamps();
            $table->primary('id_dso');
        });
    }

<iframe name="sif1" sandbox="allow-forms allow-modals allow-scripts" frameborder="0"></iframe>

I'm using mysql for database and laravel 8

CodePudding user response：

$table->unsignedBigInteger('id_rso');
$table->foreignId('id_rso')->constrained('rso');

Instead of this, just write:

$table->foreignId('id_rso')->constrained('rso');