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

Create foreign key laravel migration

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

    $table->foreign('user_id')->references('id')->on('users');
});

Laravel 8 foreign key

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

Source: laravel.com

Similar codes

6 votes126 views1 answer
Insall laravel
PHP Laravel
0 vote123 views1 answer
How to display image from aws s3 in laravel blade
PHP Laravel
12 votes126 views4 answers
Give custom field name in laravel form validation error message
PHP Laravel
1 vote148 views1 answer
Return response array laravel
PHP Laravel
8 votes119 views6 answers
Laravel composer
PHP Laravel
1 vote114 views1 answer
Laravel 6 make http request
PHP Laravel
0 vote122 views2 answers
String to array in laravel
PHP Laravel
0 vote119 views1 answer
Razorpay refund laravel
PHP Laravel
0 vote120 views1 answer
Laravel with callback
PHP Laravel
0 vote106 views2 answers
Laravel 8 query builder, Left Join / Right Join Clause
PHP Laravel