I have a real estate site with a master table of listings. Each listing belongs in one subdivision and I have a table Subdivisions with all of that data. Each subdivision has one school so I have a Schools table to describe the schools (ratings, etc).
Simply, how do I link the listing all the way to the school? In other words, this listing is in this neighborhood which is assigned to this school? That way on the display page, I can display the school's rating.
Easiest way is to have pivot table if your relationship between listing, neighbourhood and school.
This way you can use eloquent has one or hasMany relation between them and then eager load them when you pull from listing or reverse pull the listing from schools
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast