Laravel 8 foreign key

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 before migration

Schema::table('users', function ($table) {
    $table->string('email')->after('id')->nullable();
});

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

Laravel 8 foreign key

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

Source: laravel.com

Similar codes

0 vote155 views1 answer
Twig log variable
PHP
0 vote138 views2 answers
Yii2 activerecord bulk insert
PHP
0 vote165 views1 answer
Wp retrieve acf by category name
PHP Wordpress
0 vote157 views2 answers
Create model controller migration factory laravel in one command
PHP
11 votes158 views3 answers
Laravel get last month records
PHP Laravel
21 votes213 views6 answers
Php print array
PHP
0 vote136 views1 answer
Parse error: syntax error, unexpected ':', expecting ';' or '{' in //twilio-php-master/src/Twilio/autoload.php on line 61 
PHP
0 vote120 views2 answers
Octobercms mail register
PHP
0 vote161 views2 answers
Check empty laravel blade
PHP Laravel
0 vote236 views1 answer
Login with email or username codeigniter 4
PHP CodeIgniter