Hello everyone. I’m trying to wrap my head around Bubble’s Database and data structures, and the correct ways of working with it.
In the Database I created a WeeklyMenu “type.” It has several fields that represent Dishes on particular days, and Dishes are “objects” containing 4 fields (strings) that represent separate ingredients.
I understand that I can create ANOTHER type for the Dish and then reference them but…
Do I always have to create a separate Type in the DB for this Dish object, which then creates a “thing” in the DB for each dish?
Is this the “right” way to work with Bubble’s DB, even if I would NOT be quering Dishes separate from the WeeklyMenu??? And previous-made dishes would have no relevance in the future.
What feels “off” to me is having a whole Dishes table in the DB that won’t really be used except as references to “objects” that I much rather just have within WeeklyMenu (if possible). And that, if I were to delete WeeklyMenus I would also have to retroactively delete the referenced Dishes to keep the DB “clean.”
In the No SQL databases that I have experience with, I would just drop in the JS object/map on the WeeklyMenu and call it a day, but I’m not sure what’s the correct way of doing the same in within Bubble’s DB.
Thanks for any and all help.
You’re the best.