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 vote126 views1 answer
Laravel factory relationship one to many
PHP
0 vote155 views1 answer
Installer composer dans ionos
PHP
51 votes161 views5 answers
Remove item in an array php
PHP
15 votes142 views3 answers
Pass data to blade laravel
PHP Laravel
13 votes146 views6 answers
How to create model in laravel
PHP
0 vote136 views2 answers
Redirect to checkout woocommerce
PHP
1 vote138 views2 answers
{php} in smarty
PHP
0 vote128 views1 answer
Iterate over assets container statamic
PHP
0 vote122 views1 answer
Php get cookie by name preg_match
PHP
30 votes125 views5 answers
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
PHP