I am writing a product listing app that will list prodcucts in differing categories and sub categories.
Currently a prodcut can belong to one category
so I have *producttable*
that relates to
Now "some" categories will need SUB categories so what is the best approach to model this in database design?