/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 vote249 views3 answers
Email or phone required in laravel
PHP Laravel
9 votes181 views3 answers
Laravel database seeder medium
PHP Laravel
0 vote194 views1 answer
Throw 403 laravel
PHP Laravel
0 vote195 views1 answer
Laravel valet subdomain
PHP Laravel
0 vote231 views1 answer
How to make a simple mail system in Laravel without view or notification
PHP Laravel
63 votes300 views6 answers
Clear all cache in laravel
PHP Laravel
16 votes187 views4 answers
Laravel auth helper function
PHP Laravel
11 votes197 views3 answers
Laravel running a specific migration on different path
PHP Laravel
6 votes224 views2 answers
Generate application key laravel
PHP Laravel
0 vote224 views1 answer
Foreign key cosntraint laravel
PHP Laravel