/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

1 vote219 views1 answer
Wp safe redirect
PHP
0 vote236 views1 answer
Wcfm filter vendor dashboard widgets
PHP
6 votes222 views3 answers
Destrroy a session php
PHP
0 vote244 views1 answer
Laravel use variable inside callback function
PHP Laravel
3 votes186 views3 answers
Php replace all spaces with dashes
PHP
0 vote198 views1 answer
Php count second different
PHP
1 vote167 views1 answer
Laravel model find one
PHP Laravel
40 votes176 views6 answers
Laravel drop column
PHP
11 votes235 views4 answers
Get first row of array php
PHP
95 votes257 views6 answers
Str_replace php
PHP