Level 10
This will explain how to setup a many-to-many relationship and tables:
https://laravel.com/docs/9.x/eloquent-relationships#many-to-many
Dec 19, 2022
7
Level 1
How do you create migrations for pivot tables that are related to each other in Laravel ?
here is the database structure
For instance CourseByCycle table has a many to many relationship between cylces and courses (which makes it a pivot table ) and Enrollmemts table also has a many to many relationship between students and CourseByCycle( which is a pivot table) , Now Both CourseByCycle and Enrollments are pivot tables and are related to each other , How would one create migrations and perform CRUD Operations ?
Level 80
@mntimande You need to create your tables in a logical order. For example, you can’t create a foreign key until you’ve created the table that key is going to point to.
You’ll also make your life easier if you stick to Laravel’s naming conventions. Your pivot table would be named course_cycle, which indicates it relies on both a courses and a cycles table, so they’ll need to have been created first.
Level 73
@martinbean Shouldn't it be course_cycle ?
1 like
Level 15
@Tray2 that is correct, the table structure of pivot tables should be ordered in alphabetical order, it makes it easier for Laravel to link everything together without manually having to add the table and columns.
Level 73
Level 80
@Tray2 It should, yes. Was typing from mobile after having just woke up so brain wasn’t firing on all cylinders yet 😅
2 likes
Level 73
@martinbean Things that sometimes happens to us all. ;)
Please or to participate in this conversation.