Schema::create('sentence_word', function (Blueprint $table) {
$table->integer('word_id')->unsigned()->index();
$table->foreign('word_id')->references('id')->on('words');
$table->integer('sentence_id')->unsigned()->index();
$table->foreign('sentence_id')->references('id')->on('sentences');
$table->primary(['word_id', 'sentence_id']);
});
later on...
$sentence->words()->save($word);
in the pivot table (sentence_id), I want each combination to have only one entries, but it is allow multiple entries with exactly the same word sentence pair.
To ensure that each combination of word and sentence has only one entry in the pivot table, you can use the sync() method instead of save() method. The sync() method will remove any existing entries for the given sentence and then add the new entry. Here's an example:
$sentence->words()->sync([$word->id]);
This will remove any existing entries for the given sentence and then add the new entry for the given word.
Laravel doesn't support model with a composite primary key.
https://laravel.com/docs/10.x/eloquent#composite-primary-keys
However you can have composite unique keys.
@vincent15000 something like this? (its a pivot table, so it doesnt have a model)
Schema::create('sentence_word', function (Blueprint $table) {
//$table->primary(['word_id', 'sentence_id']);
$table->unique(['word_id', 'sentence_id']);
});
@TheDude Yes like this. This will assure that you have a unique (word_id, sentence_id) pair in the table.
Please or to participate in this conversation.