Fun recipe ERD paradox

[Ethan_U]

Hey guys, I’m working on creating a recipe app.

The one issue I’m having is understanding the data design.

Since a recipe’s (say tacos) ingredients can either be a product (salt) or a portion of another recipe (a salsa recipe for instance)

I am having a difficult deciding how to structure this. I created a lucid chart just a basic one to illustrate my thoughts for the moment. I’m figuring to have a yes/no column and a conditional show on two other columns so the ingredient can only be one or the other.

Is this a crazy way to think about this?