Forum Academy Marketplace Showcase Pricing Features

Market place product, categories and sub categories

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