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

3 votes78 views1 answer
Laravel go back
PHP
0 vote117 views1 answer
Phpmyadmin get actual ip
PHP
1 vote121 views1 answer
Fixuphost
PHP
0 vote109 views1 answer
Turnery expression php
PHP
49 votes174 views6 answers
Laravel add column to existing table
PHP Laravel
90 votes116 views4 answers
If text contains word then in php
PHP
0 vote111 views1 answer
Id type laravel
PHP
0 vote113 views1 answer
Php read mysql
PHP
2 votes137 views2 answers
How to get previous page name in php
PHP
9 votes143 views5 answers
Php get day number
PHP