Feb-11-2023, 05:15 PM
Hi,
assuming you use a RDBMS, the table design is pretty weird. You should have at least three tables: one for ingredients, one for receipes and one respesenting the many-to-many relation between ingredient and receipe combined with holding the needed amount / weight of the ingredient for the given receipe. Then it will be way easier to query the database using SQL.
Regards, noisefloor
assuming you use a RDBMS, the table design is pretty weird. You should have at least three tables: one for ingredients, one for receipes and one respesenting the many-to-many relation between ingredient and receipe combined with holding the needed amount / weight of the ingredient for the given receipe. Then it will be way easier to query the database using SQL.
Regards, noisefloor