[Solved] Database schema with categories, subcategories and products [closed]
I would recommend structuring your category table like below: Category ———- CategoryId ParentCategoryId –nullable CategoryName I’m not sure what you want to store in products so it’s hard for me to tell you how to design that, but at a minimum you should have a CategoryId column in there. I would leave it to your … Read more