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 vote151 views1 answer
Laravel db query log string replacements
PHP Laravel
0 vote157 views1 answer
How to excluse csrf in a route laravel
PHP Laravel
6 votes192 views3 answers
Check the php version in ubuntu
PHP
0 vote128 views1 answer
Undefined offset: 0 at laravel\framework\src\Illuminate\Routing\Router.php
PHP
2 votes189 views1 answer
How to set a comment on table using Laravel Schema
PHP
10 votes123 views4 answers
Error logs wp
PHP
4 votes130 views2 answers
Laravel order by random
PHP
5 votes148 views3 answers
Enum table in laravel
PHP Laravel
0 vote180 views1 answer
Install sage
PHP
0 vote170 views1 answer
Wordpress plugin functions exist
PHP Wordpress