I am trying to develop an ecommerce solution but stuck on the categories management issue and don't know how to proceed further.
See, A category will have a parent category, which in-return can also point to another parent and so on, until the root category is reached. I tried to design the following database schema,
Please tell me if that's right ?
OR Is there any tutorial on categories and parent categories that can help me understand this scenario better ?