How to set the foreign key name in php laravel?

user_12707241 0
Viewed 4792

How can I set the name of a foreign key in php laravel?

Schema::table('TABLE_NAME', function (Blueprint $table) {
        $table->foreign(XXX)
            ->references(XXX)
            ->on('REF_TABLE')
            ->onDelete('cascade');

            // HOW TO ACHIEVE SOMETHING LIKE THIS?
            //->name('Custom name of foreign key.')
            //->comment('Custom comment for foreign key.')        
    });
laravel foreign-keys php
3 Answers

You can specify a custom name by filling the second foreign param :

->foreign('XXX', 'my_custom_name')
user_35721560

when you build your foreign key column, you can build it like:

 $table->UnsignedBigInteger('xxx')->comment("comment for this column");

see this link.

you can also find the details in Laravel column-modifiers.

user_105735600

You can make the foreign key in the following way:-

        $table->unsignedInteger('XXXX')
            ->nullable();
        $table->foreign('XXXX')
            ->references('id')
            ->on('REF_TABLE')
            ->onDelete('cascade');
user_38420060
Related