Laravel与多个模型的关系

Question

I am building a blog application and I have

Post, City, Neighbourhood, SubNeighbourhood.

The relations that I have until now are between City, Neighbourhood and subNeighbourhood like follows:

subNeighbourhood belongs to Neighbourhood 
Neighbourhood belongs to city

The second relation is like

City hasMany Neighbourhoods 
Neighbourhood hasMany subNeighbourhoods 

My problems are when I create the post. The posts table have id_city, id_neighbourhood and id_subNeighbourhood.

The questions that I have are:

If the post structure is correct? I feel like having many "id_..." is not ok.

Second issue is how do I write the relation in posts? All the columns "id_..." are having foreign keys to each corresponding table.

Answer 1

For what I can understand from your explanation the post table should have only a subneighbourhood_id field, in the Post class the relation should be:

public function subneighbourhood()
{
    return $this->belongsTo('App\Subneighbourhood');

So a Post belongs to a Subneighbourhood that belongs to a Neighbourhood that belongs to a City