Breaking News: Grepper is joining You.com. Read the official announcement!

laravel foreign key

Add Answer

Courageous Cod answered on December 9, 2020 Popularity 10/10 Helpfulness 9/10

answer laravel foreign key

related add foreign key column laravel 5.8

related foreign key in Laravel

related create foreign key laravel migration

related add foreign key in laravel migration

related laravel foreign key constraint

related laravel change foreign key name

related foreign key laravel migration

related laravel foreign

related Laravel adding Foreign Key Constraints

laravel foreign key

Comment

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();
});

Popularity 10/10 Helpfulness 9/10 Language php

Source: Grepper

Tags: key laravel php

Link to this answer
Share Copy Link

Contributed on Dec 09 2020

Courageous Cod

0 Answers Avg Quality 2/10

Closely Related Answers

add foreign key column laravel 5.8

Comment

update your `integer('user_id')` to `bigInteger('user_id')`
public function up() { 
        Schema::create('evaluation', function (Blueprint $table) { 
            $table->increments('id'); 
            $table->bigInteger('user_id')->unsigned()->index(); 
            $table->timestamps();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
        });
    }

Popularity 10/10 Helpfulness 7/10 Language php

Source: stackoverflow.com

Tags: add

Link to this answer
Share Copy Link

Contributed on Oct 28 2021

Splendid Stoat

0 Answers Avg Quality 2/10

foreign key in Laravel

Comment

// one_line code for foreign in laravel
$table->foreignId('user_id')->constrained()->onDelete('cascade');

Popularity 10/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Jul 05 2022

Enthusiastic Emu

0 Answers Avg Quality 2/10

create foreign key laravel migration

Comment

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

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

Popularity 10/10 Helpfulness 6/10 Language php

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Feb 15 2021

Super Starling

0 Answers Avg Quality 2/10

add foreign key in laravel migration

Comment

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

Popularity 10/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: add

Link to this answer
Share Copy Link

Contributed on Aug 23 2022

nricciardi

0 Answers Avg Quality 2/10

laravel foreign key constraint

Comment

public function up()
{
    Schema::create('replies', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->text('body');
        $table->unsignedBigInteger('question_id');
        $table->integer('user_id')->unsigned();
        $table->foreign('question_id')->references('id')->on('questions')->onDelete('cascade');
        $table->timestamps();
    });
}

Popularity 10/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: key

Link to this answer
Share Copy Link

Contributed on Sep 27 2021

Brave Butterfly

0 Answers Avg Quality 2/10

laravel change foreign key name

Comment

//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');
        });
    }
}

Popularity 10/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: key

Link to this answer
Share Copy Link

Contributed on Jul 02 2021

Fragile Fish

0 Answers Avg Quality 2/10

foreign key laravel migration

Comment

$table->foreign('column_name')->references('id')->on('table_name')->onDelete('cascade');

Popularity 10/10 Helpfulness 5/10 Language php

Source: Grepper

Tags: key

Link to this answer
Share Copy Link

Contributed on Feb 05 2021

Super Starling

0 Answers Avg Quality 2/10

laravel foreign

Comment

$table->unsignedBigInteger('user_id');
$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade')

Popularity 9/10 Helpfulness 4/10 Language php

Source: Grepper

Tags: laravel

Link to this answer
Share Copy Link

Contributed on Sep 24 2022

salah mohamed

0 Answers Avg Quality 2/10

Laravel adding Foreign Key Constraints

Comment

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

Popularity 10/10 Helpfulness 4/10 Language php

Source: laravel.com

Tags: constraints cons

Link to this answer
Share Copy Link

Contributed on Jun 16 2021

kelraf

0 Answers Avg Quality 2/10

laravel foreign key

Contents

More Related Answers

laravel foreign key

Closely Related Answers

add foreign key column laravel 5.8

foreign key in Laravel

create foreign key laravel migration

add foreign key in laravel migration

laravel foreign key constraint

laravel change foreign key name

foreign key laravel migration

laravel foreign

Laravel adding Foreign Key Constraints

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.