/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

4 votes220 views2 answers
Validate year laravel
PHP Laravel
0 vote167 views4 answers
How to redirect to another page after login in laravel
PHP Laravel
0 vote173 views2 answers
Laravel-check-if-related-model-exists
PHP Laravel
0 vote185 views2 answers
Laravel required_if fileld has value
PHP Laravel
8 votes163 views4 answers
Laravel unique validation on multiple columns
PHP Laravel
1 vote181 views1 answer
Integer nullable laravel
PHP Laravel
31 votes173 views5 answers
How to make db seeder in laravel
PHP Laravel
10 votes199 views2 answers
Array to string conversion in laravel controller
PHP Laravel
2 votes161 views2 answers
Laravel include config
PHP Laravel
5 votes172 views3 answers
Laravel created_at where date format
PHP Laravel