Breaking News: Grepper is joining You.com. Read the official announcement!

add foreign key to existing table postgresql with laravel migrations

@CodeGrepperManu answered on August 23, 2022 Popularity 2/10 Helpfulness 8/10

answer add foreign key to existing table postgresql with laravel migrations

related add foreign key in laravel migration

add foreign key to existing table postgresql with laravel migrations

Comment

Schema::create('users_contact', function (Blueprint $table) {
            $table->id();
            $table->text('address');
            $table->unsignedBigInteger('id');
            $table->unsignedBigInteger('contact_no')->nullable();            
            $table->integer('user_contact_id')->nullable();
            $table->string('tag_string');
            $table->text('second_email')->nullable();
            $table->timestamps();
               
            $table->foreign('user_contact_id')->references('id')->on('users');
        });

Popularity 2/10 Helpfulness 8/10 Language sql

Source: Grepper

Tags: add key laravel-migrations postgresql sql

Link to this answer
Share Copy Link

Contributed on Jul 15 2024

@CodeGrepperManu

0 Answers Avg Quality 2/10

Closely Related Answers

add foreign key in laravel migration

Comment

$table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');

Popularity 10/10 Helpfulness 5/10 Language php

Source: stackoverflow.com

Tags: add

Link to this answer
Share Copy Link

Contributed on Aug 23 2022

Nicola Ricciardi

0 Answers Avg Quality 2/10

add foreign key in laravel migration

Comment

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class AddForeignKeyToTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('your_table_name', function (Blueprint $table) {
            $table->foreign('foreign_key_column')->references('referenced_column')->on('referenced_table')->onDelete('cascade');
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::table('your_table_name', function (Blueprint $table) {
            $table->dropForeign(['foreign_key_column']);
        });
    }
}

Popularity 8/10 Helpfulness 3/10 Language php

Source: Grepper

Link to this answer
Share Copy Link

Contributed on Sep 12 2023

YOU.com

0 Answers Avg Quality 2/10

add foreign key to existing table postgresql with laravel migrations

Contents

More Related Answers

add foreign key to existing table postgresql with laravel migrations

Closely Related Answers

add foreign key in laravel migration

add foreign key in laravel migration

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.