/PHP/Laravel/Foreign key in laravel migration

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

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 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

Similar codes

0 vote188 views1 answer
Get nearby from longitude and latitude in laravel
PHP Laravel
21 votes194 views2 answers
Long text in laravel migration
PHP Laravel
42 votes193 views5 answers
Create controller laravel with model
PHP Laravel
-1 vote193 views1 answer
How to check if there is an authenticated user laravel
PHP Laravel
9 votes163 views3 answers
Laravel database seeder medium
PHP Laravel
1 vote187 views1 answer
Get all errors view laravel
PHP Laravel
18 votes233 views5 answers
Create model, controller and migration in single command laravel
PHP Laravel
0 vote170 views6 answers
Array value auto fill in old value laravel 8
PHP Laravel
2 votes184 views2 answers
The requested url was not found on this server. laravel
PHP Laravel
1 vote196 views1 answer
Types of looping directives in laravel
PHP Laravel