Hi people, first off ill detail my database setup being:
product_id, product_title, etc
tag_id, tag_name, tag_value
essentially I cant figure out the best way to implement a tagging system, would it be best to add a row to the tag table like ‘parent_id’ as an enum/set type and include the product id, or to have a seperate table entirely like ‘tags_to_products’, which would have an id, product id and tag id. Im just wondering if theres a better way to execute this?
Thanks! :thumb: