Prevent Same Foreign Key pair in a table in Laravel 5.4

Asked Nov 30 '17 at 15:06

Active Nov 30 '17 at 15:06

Viewed 48 times

I have schedules table which contain student_id and class_id as it's foreign key. I know I can use syntax $table->primary(['student_id', 'class_id']) to prevent same foreign key to pair more than one time in a table, but the problem is my schedules table also has primary key called id, so I can't assign foreign key as primary (will get multiple primary key error). Is there any better approach to solve my problem (make foreign key as primary so they'll never pair more than one time)?

Thanks..

asked Nov 30 '17 at 15:06

adrianriyadi

you're looking for something called `unique` – Chay22 Nov 30 '17 at 15:09
At the database level, MySql supports [unique constraints](https://stackoverflow.com/q/635937/314291) which will be enforced – StuartLC Nov 30 '17 at 15:09
how can I achieve this by Laravel syntax? assign unique() in `student_id` and `class_id`? – adrianriyadi Nov 30 '17 at 15:21
2

$table->unique(['student_id', 'class_id']) – Achraf Khouadja Nov 30 '17 at 15:28
i will try it.. thanks a lot – adrianriyadi Nov 30 '17 at 15:55

Prevent Same Foreign Key pair in a table in Laravel 5.4

0 Answers0