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

1 vote91 views1 answer
Laravel eloquent get column
PHP
18 votes89 views1 answer
Specified key was too long; max key length is 767 bytes (s
PHP
0 vote110 views3 answers
Writing into the database with one click laravel
PHP Laravel
11 votes94 views4 answers
Laravel create resource controller
PHP
1 vote101 views3 answers
Not equal in laravel blade
PHP
6 votes93 views2 answers
Php cut off first x characters
PHP
1 vote104 views1 answer
Display summernonte data with string limit laravel
PHP
0 vote108 views1 answer
Laravel collection last
PHP Laravel
5 votes89 views3 answers
Get last month php
PHP
0 vote101 views3 answers
Php remove slashes from json
PHP