I’m working on a schema for a cocktail recipe app. I have ingredients split into three tables based on taxonomy: Broad Spirit Types (eg Gin), Narrow Spirit Types (eg London Dry Gin), and Bottles (eg Beefeater). In the wild, recipes can call for any t...
I already have a similar set up, which I based on that many-to-many support article. My join table is called “Per-Recipe Line Items.” You can see it in the link I included.
The complexity I’m trying to solve for is in that I have 3 ingredient types. ...
