/PHP/Laravel/Add foreign key column laravel 5.8

Add foreign key column laravel 5.8

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

Create foreign key laravel migration

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

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

Add foreign key column laravel 5.8

update your `integer('user_id')` to `bigInteger('user_id')`
public function up() { 
        Schema::create('evaluation', function (Blueprint $table) { 
            $table->increments('id'); 
            $table->bigInteger('user_id')->unsigned()->index(); 
            $table->timestamps();
            $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');
        });
    }

Source: stackoverflow.com

Similar codes

0 vote374 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP Laravel
12 votes432 views2 answers
Creating a Basic Route in Laravel 8
PHP Laravel
5 votes348 views2 answers
Laravel print exception message
PHP Laravel
8 votes350 views3 answers
Laravel redirect back with errors and input
PHP Laravel
1 vote389 views1 answer
Laravel format number blade
PHP Laravel
1 vote366 views2 answers
How to delete image from aws using laravel 8
PHP Laravel
0 vote347 views1 answer
Laravel bd query
PHP Laravel
1 vote385 views2 answers
Laravel ckeditor
PHP Laravel
26 votes355 views6 answers
Laravel validation integer
PHP Laravel
0 vote397 views1 answer
Laravel faker select between options
PHP Laravel