/PHP/Laravel/Laravel change foreign key name

Laravel change foreign key name

Laravel foreign key

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
    $table->foreignId('user_id')->constrained();
});

Create foreign key laravel migration

Schema::table('posts', function (Blueprint $table) {
    $table->unsignedBigInteger('user_id');

    $table->foreign('user_id')->references('id')->on('users');
});

Laravel adding Foreign Key Constraints

$table->foreignId('user_id')
      ->constrained("users") <- // You don't need to specify table if it matched laravel naming conventions.
      ->onUpdate('cascade')
      ->onDelete('cascade');

Source: laravel.com

Laravel change foreign key name

//Note : Before Renaming Foreign, You Must Need To Delete Old Foreign And Assign New One
class RenameColumn extends Migration
{

    public function up()
    {
        Schema::table('holidays', function(Blueprint $table) {
            $table->dropForeign('holidays_account_id_foreign');
            $table->renameColumn('account_id ', 'engagement_id');

            $table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade');
        });
    }

    public function down()
    {
        Schema::table('holidays', function(Blueprint $table) {
            $table->dropForeign('holidays_engagement_id_foreign');
            $table->renameColumn('account_id ', 'engagement_id');

            $table->foreign('account_id')->references('id')->on('accounts')->onDelete('cascade');
        });
    }
}

Source: stackoverflow.com

Similar codes

0 vote364 views7 answers
Debugger in laravel
PHP Laravel
0 vote348 views1 answer
Handling deadlocks laravel
PHP Laravel
0 vote358 views1 answer
Set laravel local time to indonesia
PHP Laravel
0 vote361 views1 answer
Remove public or index file from url in laravel
PHP Laravel
15 votes363 views4 answers
Change existing migration laravel
PHP Laravel
12 votes365 views5 answers
Laravel transactions
PHP Laravel
0 vote403 views1 answer
What is actullay work model in laravel
PHP Laravel
0 vote389 views3 answers
Permissions for laravel deployment
PHP Laravel
4 votes407 views6 answers
Jwt for Laravel
PHP Laravel
24 votes379 views2 answers
How to use join in laravel 5.4
PHP Laravel