I have a question regarding to whether to join table or create a property in the table i need to get data from.
For example, i have companies, events, users, reviews.
Rule 1: company can create many event
Rule 2: User will complete a review task based on event posted for the company.
Rule 3: User might need to complete multiple task for an event (which mean one event may consist multiple review for one/many user)
How will you guys do it if only want to get the data for company and reviews made for the company only without event details? Should i create a relationship for company_reviews or add a field company_id in the reviews table?
Appreciate for any feedback, thanks.
I would definitely take the approach of establishing relationships. You can then get the reviews for a company without the event details by leveraging a hasManyThrough relationship.
Documentation here: https://laravel.com/docs/master/eloquent-relationships#has-many-through
Please or to participate in this conversation.