Foreign key string laravel

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();
});

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 adding Foreign Key Constraints

$table->foreignId('user_id')
      ->constrained("users") <- // You don't need to specify table if it matched laravel naming conventions.
      ->onUpdate('cascade')
      ->onDelete('cascade');

Source: laravel.com

Laravel field types from database field type

// in laravel if error of missing pdomysql driver issue the command
// composer require doctrine/dbal
DB::connection()->getDoctrineColumn($table_name, $field_name)->getType()->getName()

Foreign key string laravel

Schema::table('portfolios', function (Blueprint $table) {
            $table->string('filter_alias');
            $table->foreign('filter_alias')->cascadeOnDelete()->references('alias')->on('filters');
        });

-1

Similar codes

4 votes217 views3 answers
Softdeletes laravel
PHP
30 votes222 views6 answers
Artisan make auth
PHP
12 votes215 views5 answers
Drop column migration laravel
PHP
11 votes262 views5 answers
Get count laravel
PHP Laravel
18 votes233 views6 answers
Set timezone in php
PHP
0 vote246 views1 answer
Howto+add+header+bar+laravel+app
PHP Laravel
0 vote219 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP
0 vote228 views1 answer
Query builder laravel getmedia undefined method
PHP
0 vote236 views1 answer
Numeros positivos input laravel
PHP
2 votes171 views1 answer
Php line break in echo
PHP