Tabel structure for hashtags belongs to posts

Hey, I'm facing a problem should I create separate table for storing hashtags belongs to post and hashtags belongs to comment or should I create single for both like this

post_comment_hashtags {
 post_id, // primary key 
comment_id, // primary key 
hashtag_id, // primary key
}

And what is the best way to store both? Please guide me.

drgreen

2 years ago

Level 28

What you're looking for could be a many-to-many polymorphic relation between posts, comments and tags.

posts
    id - integer
 
comments
    id - integer
 
tags
    id - integer
    name - string
 
taggables
    tag_id - integer
    taggable_id - integer
    taggable_type - string

You can read further about it here https://laravel.com/docs/11.x/eloquent-relationships#many-to-many-polymorphic-relations

Please or to participate in this conversation.