How can I create unique index, that requires a set of attributes to be unique?-CodePudding

Hello Stack overflowers

I came up with a problem with Laravel, and I'm not sure how I can solve it.

The situation is as following:

I got a migration, with the name 'adresses':

Schema::create('adresses', function (Blueprint $table) {
    $table->id();
    $table->string('adress'); //adress
    $table->integer('houseNumber'); //house number
    $table->string('houseNumberAddition')->nullable(); //house number addition
    $table->timestamps();
});

What I would like to achieve: I want the adress, houseNumber and houseNumberAddition together, to become 1 unique value.

Normally you would add the unique() function, to make specific fields unique. But I want the combination of adress, houseNumber and houseNumberAddition together, to become one unique value.

(because houseNumber and houseNumberAddition will be used more than once, while the combination with adress, houseNumber and houseNumberAddition will only exist once in my database.)

I hope somebody got some fancy trick to solve this.

Thanks for helping!

Dave

CodePudding user response：

You may combine the 3 columns in one unique index

$table->unique(['adress', 'houseNumber', 'houseNumberAddition']);