/PHP/Create foreign key laravel migration

Create foreign key laravel migration

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

Make a forign key in migrations using laravel 8

$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 8 foreign key migration

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

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

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

Source: laravel.com

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

Similar codes

49 votes332 views6 answers
Laravel when
PHP
0 vote327 views1 answer
Detect mobile device laravel
PHP
0 vote321 views1 answer
Mongodb/mongodb[dev-master, 1.10.0, ..., v1.10.x-dev] require ext-mongodb ^1.11.0 -> it is missing from your system. Install or enable PHP's mongodb extension
PHP
0 vote303 views1 answer
Php check if string contains words from array
PHP
1 vote351 views2 answers
Showing from to in larvel pagination
PHP
0 vote352 views1 answer
Password strength php
PHP
0 vote344 views1 answer
Disable Specific Plugin Update
PHP
18 votes315 views6 answers
Carbon create from format
PHP
1 vote345 views2 answers
Wordpress login programmatically
PHP
4 votes304 views1 answer
Ubuntu set alternatives
PHP