Relationships between 3 tables

Hi Guys, I have these 3 tables:

Jobs
- id
- name
Measures
- id
- name
Jobs_Measures
- job_id
- measure_id

Each Job can have multiple Measures and each Measure can be assigned multiple Jobs. What would be the best way to define eloquent relationships in such a scenerio? Thanks for any tips. HT

Randy_Johnson

2 years ago

Level 8

So a many to many. I would recommend using Eloquent. Eloquent is the icing on the cake.

https://laravel.com/docs/10.x/eloquent-relationships#many-to-many

DhPandya

2 years ago

Level 12

@ht-ftw You should also add job_id to your measures table. It will helps you to retrive the messaures of your jobs.

Randy_Johnson

2 years ago

Level 8

@DhPandya You don't need to add job_id to your measures because you have already referenced it in the M2M table. HT-ftw just read the information on the url I sent you.

Please or to participate in this conversation.