So i am building a fiverr type app. I need help with the structure of data base for product, categories and sub categories please.
Product - Design a website banner for wordpress
Category - Graphic Design
Sub Category - Website design
I will have 4 main predefined categories
Video and editing
Programming & No code
Each category will have a predefined list of sub categories E.g for graphic design below
Art & Illustratio
Business Cards and Letter heads
Industrial & Product Design
Logo & Brand Identity
Packaging & Label Designs
Social Media Design
My current Database
The form sellers would fill out
The repeating group i would use to do a search
So a seller would fill out a form and create their product and i would like to capture the details of the category and sub category for the product that updates in the product, category and sub category data type as well.
So the product updates into the data base, but i need the sub category and category to update as well.
I think my database is not properly structured.
At the moment i am manually typing in the categories and subcategories for the accordion and dropdowns etc.
PS - and also best way to show the categories and sub categories with the above model in place - Option sets or data base?
Please can you help