Hi Guys
So i am building a fiverr type app. I need help with the structure of data base for product, categories and sub categories please.
E.g
Product - Design a website banner for wordpress
Category - Graphic Design
Sub Category - Website design
I will have 4 main predefined categories
Graphic design
Video and editing
Digital Marketing
Programming & No code
Each category will have a predefined list of sub categories E.g for graphic design below
App Design
Art & Illustratio
Gaming Design
Brochure Design
Business Cards and Letter heads
Catalog Design
Email Design
Fashion Design
Industrial & Product Design
Infographic Design
Jewellery Design
Logo & Brand Identity
Other Design
Packaging & Label Designs
Presentation Design
Print Design
Signage Design
Social Media Design
T-Shirt Design
Website 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
Thanks