Polymorphic One to Many Relationship

Polymorphic One to Many Relationship

Demo details:

Business Rules:

Relations Diagram:

Relationship Details:

Eloquent Models:

class Man
{
    public function cars()
    {
        return $this->morphMany(Car::class, 'buyer');
    }
}

class Woman
{
    public function cars()
    {
        return $this->morphMany(Car::class, 'buyer');
    }
}

class Car
{
    public function buyer()
    {
        return $this->morphTo();
    }
}

Database Migrations:

Schema::create('men', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('women', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');
});

Schema::create('cars', function (Blueprint $table) {
    $table->increments('id');
    $table->string('name');

    $table->integer('buyer_id')->unsigned()->index()->nullable();
    $table->string('buyer_type')->nullable();   
    // or use $table->morphs(‘buyer’); instead of "buyer_id" and "buyer_type"

});

Store Records:

// Create relation between buyer (Man/Woman) and Car.

$man->cars()->saveMany([
   $car1, 
   $car2,
]);

$woman->cars()->saveMany([
   $car1, 
   $car2,
]);

// Or use the save() function for single model.

$man->cars()->save($car);
$woman->cars()->save($car);

// Create relation between Car and buyer (Men/Women).

$car1->buyer()->associate($man)->save();
$car2->buyer()->associate($woman)->save();

Retrieve Records:

// Get buyer (Man/Woman) Cars

$men->cars
$women->cars

// Get Car buyer (Man and Woman)

$car->buyer