This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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. ...
