How to model a many-to-many relation using Spring Webflux in Kotlin?
How do I efficiently model a many-to-many relationship in Spring Webflux using R2DBC with a MariaDB in Kotlin?
Let's assume, I want to model the relationship between recipes and ingredients. One recipe may contain multiple ingredients, and one ingredient may belong to many recipes, i.e.
Recipes
id
name
1
Caesar Salad
Pivot (Ingredient_Recipe)
id
recipe_id
ingredient_id
grams
1
1
1
100
2
1
2
200
Ingredients
id
name
1
Lettuce
2
Cheese
My initial idea was to create one model per table....