Level 102
If a user can have multiple sections and sections can have multiple users, then it is correct. It's called a many to many relationship https://laravel.com/docs/9.x/eloquent-relationships#many-to-many
1 like
Apr 2, 2022
5
Level 8
Eloquent relationship
I'm confused about setting the eloquent relationship and the table in my database. I have a Teacher which is saved in the users table with the role 1, and a Student which is also saved in the users table but with the role of 2.
The student belongs to a section and in the student dashboard, I will show who is the Adviser of that section he/she belongs to.
Currently, I have the sections table, every section has an Adviser, and every section can only have one adviser.
I'm thinking of creating section_user, is this the right approach?
// section_user
+------+-------------+----------------+
| id | user_id | section_id |
+------+-------------+----------------+
| 1 | 1 | 2 |
+------+-------------+----------------+
// users
+------+-----------+----------+----------------+
| id | name | role | section_id |
+------+-----------+----------+----------------+
| 1 | teacher | 1 | null |
| 2 | student | 2 | 2 |
+------+-----------+----------+----------------+
// sections
+------+-------------+
| id | name |
+------+-------------+
| 1 | Section A |
| 2 | Section B |
+------+-------------+
Level 8
@Sinnbeck For example, I've implemented the many-to-many relationship, and I am a Student logged in, how can I show the Adviser in that section?
Level 102
@benjamin1509 you will need something to determine that. You could add an advisor_id to the sections table.
1 like
Level 8
@Sinnbeck I will add advisor_id column to the sections table, so when assigning a teacher to a section save the user_id and section_id to section_user table, and update the sections table column advisor_id.
Level 8
@Sinnbeck and in my Section model, add a method advisor with belongsTo(User::class)
Please or to participate in this conversation.