/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

1 vote101 views1 answer
Laravel check if eloquent just created
PHP Laravel
9 votes145 views6 answers
Laravel validation custom message
PHP Laravel
16 votes141 views6 answers
Laravel redirect back
PHP Laravel
18 votes133 views6 answers
Where clause in laravel
PHP Laravel
16 votes133 views5 answers
Laravel one command for model table and controller
PHP Laravel
0 vote135 views1 answer
Get records from Sunday to Sunday laravel
PHP Laravel
3 votes148 views4 answers
Laravel where has Relation
PHP Laravel
3 votes140 views5 answers
Get current locale laravel
PHP Laravel
10 votes148 views2 answers
Create model in laravel command line
PHP Laravel
12 votes140 views6 answers
Laravel model where
PHP Laravel