/PHP/Laravel/Foreign key laravel migration

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 vote262 views6 answers
Socialite laravel 7
PHP Laravel
14 votes229 views3 answers
Log facade laravel
PHP Laravel
0 vote292 views1 answer
How to take last entry in database in laravel Method Three
PHP Laravel
0 vote232 views3 answers
Run queue after x minutes laravel
PHP Laravel
0 vote220 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
11 votes268 views2 answers
Command laravel for php artisan make :auth
PHP Laravel
33 votes348 views6 answers
Laravel carbon
PHP Laravel
12 votes285 views6 answers
Laravel redirect back with input
PHP Laravel
43 votes226 views6 answers
Laravel create migration add column
PHP Laravel
0 vote211 views1 answer
Import separate graphql file laravel
PHP Laravel