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

1 vote220 views1 answer
How to catch query exception in laravel 8
PHP Laravel
44 votes206 views6 answers
Call seeder laravel
PHP Laravel
0 vote215 views1 answer
Remove controller cache laravel
PHP Laravel
-1 vote263 views1 answer
Validate rule if row exist laravel
PHP Laravel
29 votes197 views6 answers
Where like laravel
PHP Laravel
12 votes217 views3 answers
Call controller function from another controller laravel
PHP Laravel
-1 vote203 views1 answer
Laravel list of tables
PHP Laravel
13 votes190 views6 answers
Find auth laravel
PHP Laravel
0 vote202 views1 answer
Clear from faild_jobs laravel
PHP Laravel
2 votes223 views3 answers
Laravel Create Custom Artisan Command
PHP Laravel