Laravel 8 foreign key

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

Foreign key in laravel migration

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

Foreign key laravel migration

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

Laravel before migration

Schema::table('users', function ($table) {
    $table->string('email')->after('id')->nullable();
});

Create foreign key laravel migration

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

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

Laravel 8 foreign key

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

Source: laravel.com

Similar codes

7 votes291 views4 answers
Laravel is route name
PHP Laravel
-2 votes211 views1 answer
Laravel model bind with route in model
PHP Laravel
0 vote208 views2 answers
Laravel file path
PHP Laravel
0 vote206 views1 answer
Laravel seeding with relationships
PHP Laravel
1 vote201 views1 answer
Check which database connect laravel
PHP Laravel
50 votes556 views6 answers
Add new column in laravel migration
PHP Laravel
1 vote220 views2 answers
Laravel route group middleware prefix
PHP Laravel
2 votes230 views2 answers
Laravel switch
PHP Laravel
1 vote198 views1 answer
DB::connection('local')->create() laravel
PHP Laravel
1 vote213 views1 answer
Causes of class not found in laravel
PHP Laravel