php - Laravel RelationShips eloquent Laravel with ( 5 tables )

Question

I have 5 tables

• Products
  -- Categories
  --- SubCategories
  ---- Marks
  ----- Suppliers
  

I want to know how to make relationship I have Product Model structure with :

 namespace AppModelsProducts;

use IlluminateDatabaseEloquentFactoriesHasFactory;
use IlluminateDatabaseEloquentModel;

class Product extends Model
{
    use HasFactory;
    protected $fillable = [.... ];

    public function categorie(){
      return $this->belongTo(categories::class);
    }

    public function sub_categorie(){
      return $this->belongTo(sub_categorie::class);
    }

    public function marks(){
      return $this->belongTo(marks::class);
    }

    public function suppliers(){
      return $this->belongTo(suppliers::class);
    }
}

i want to know if it's correct ? Another Question how would be looks other Model relationships such Suppliers, Categories, SubCategories ...

question from:https://stackoverflow.com/questions/65908019/laravel-relationships-eloquent-laravel-with-5-tables

Answer 1

It depends on the cardinality and the foreign_keys that are involved.

Products

-- Categories

--- SubCategories

---- Marks

----- Suppliers

The context that you gave me, I'm guessing that each table depends on the previous one as showed in the context that you gave. If so, then you can do the following:

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Suppliers extends Model
{
    protected $fillable = [.... ];

    public function mark()
    {
        return $this->belongsTo(Mark::class);
    }
}

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Marks extends Model
{
    protected $fillable = [.... ];

    public function subCategorie()
    {
        return $this->belongsTo(SubCategorie::class);
    }
}

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class SubCategory extends Model
{
    protected $fillable = [.... ];

    public function categorie()
    {
        return $this->belongsTo(Categorie::class);
    }
}

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Categorie extends Model
{
    protected $fillable = [.... ];

    public function categorie()
    {
        return $this->belongsTo(Product::class);
    }
}

<?php

namespace AppModels;

use IlluminateDatabaseEloquentModel;

class Product extends Model
{
    protected $fillable = [.... ];
}

For more in depht inormation, you can consult the section about relationshipts on laravel docs: https://laravel.com/docs/8.x/eloquent-relationships.