Crud operations for Category and Sub-Category

[neon-lab-dev]

Problem

Currently we have category and sub-category are free text and user can give anything.

Solution

We need to provide ability for the user to create set of category and related sub-category and related operations like delete or update the same.

Discussions

• The product schema to update to include sub-category and sub-category2.
• The sub-category and sub-category2 can never be null.
• We need to update the fetchProductAPI to facilitage search based on the 'category', 'sub-category and 'sub-category2. It should not be search like rather should be equal.
• We need to create the category table where fields will be id, name, Type(root(default), non-root), linked-categories(comma separated) and generic fields.

Linked to: #1