Difference between polymorphic and Standard relationship in Laravel

• In standard relationships, you have a straightforward connection between two models using foreign key constraints.
• For example, you might have a Post model and a Comment model, where each comment belongs to a post. In this case, you would have a posts table and a comments table. The comments table would have a foreign key column like post_id that references the id column in the posts table.
• You define the relationship in the models, and Eloquent provides methods to query and retrieve related data.

// Post Model
class Post extends Model
{
    public function comments()
    {
        return $this->hasMany(Comment::class);
    }
}

// Comment Model
class Comment extends Model
{
    public function post()
    {
        return $this->belongsTo(Post::class);
    }
}

// Get comments for a post
$comments = Post::find(1)->comments;

• Polymorphic relationships allow a model to belong to more than one type of other model on a single association.
• This is useful when you have entities that can be associated with multiple types of other entities without having to create a separate table for each relationship.
• In a polymorphic relationship, the related model's type and ID are stored in columns on the calling model's table.
• For example, you might have a Comment model that can belong to both Post and Video models. In this case, you would have a comments table with commentable_type and commentable_id columns.

// Comment Model
class Comment extends Model
{
    public function commentable()
    {
        return $this->morphTo();
    }
}

// Post Model
class Post extends Model
{
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

// Video Model
class Video extends Model
{
    public function comments()
    {
        return $this->morphMany(Comment::class, 'commentable');
    }
}

// Get comments for a post
$comments = Post::find(1)->comments;

// Get comments for a video
$comments = Video::find(1)->comments;