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

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

Laravel 8 foreign key

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

Source: laravel.com

Similar codes

0 vote271 views1 answer
Calculate average in eager loading laravel
PHP
11 votes648 views5 answers
Php header allow cross origin
PHP
1 vote276 views2 answers
Laravel eloquent multiple join
PHP
-2 votes313 views1 answer
Laravel if else condition in query
PHP Laravel
1 vote319 views3 answers
Php hide errors
PHP
1 vote325 views1 answer
Key of last element php
PHP
1 vote256 views1 answer
Print url in view yii2
PHP
14 votes305 views5 answers
Laravel eloquent get last record
PHP Laravel
4 votes270 views1 answer
Php reading a file line by line
PHP
1 vote278 views4 answers
Php to html
PHP