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

Make a forign key in migrations using laravel 8

$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');

Create foreign key laravel migration

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

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

Laravel foreign key constraint

public function up()
{
    Schema::create('replies', function (Blueprint $table) {
        $table->bigIncrements('id');
        $table->text('body');
        $table->unsignedBigInteger('question_id');
        $table->integer('user_id')->unsigned();
        $table->foreign('question_id')->references('id')->on('questions')->onDelete('cascade');
        $table->timestamps();
    });
}

Source: stackoverflow.com

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 vote204 views1 answer
Logout from all the devices in the jwt api laravel
PHP
19 votes233 views5 answers
Php get random element from array
PHP
19 votes220 views4 answers
Php json_decode not working
PHP
18 votes199 views6 answers
Php sort multidimensional array
PHP
0 vote188 views1 answer
Update php version in docker container
PHP
26 votes186 views6 answers
Php return json
PHP
0 vote224 views1 answer
Location php ini mac os
PHP
4 votes234 views1 answer
How to check query execution time in laravel
PHP Laravel
0 vote188 views2 answers
PHP $argv echo with number of words
PHP
0 vote204 views2 answers
Laravel migration table softdeletes
PHP Laravel