Good day everyone,
I’m creating an app where I have a “Items” table and a “Categories” table.
Originally, I had a column “itemCategory” within the Items table, so I could filter the items by that category. (e.g: “fruits”, “vegetables”, “meat”, “frozen”, “juices”)
But now, I would like to be able to set several categories to a single item. This resembles the concept of adding “tags” to the items.
The idea is that later I would be able to filter easily all items that meet a set of selected “categories”, so as an example, I could then filter all the “frozen fruits” by selecting the “fruits” and the “frozen” categories.
Also ideally it would be possible for the user to add more “categories” when creating or editing an item.
I’ve seen the column tupe “EnumList”, but I’m not sure if that will be the best solution for later being able to filter easily by one or multiple “categories” (“frozen fruits” or “frozen vegetables”)