I have 4 different tables that each contain a single “name” column. You could think of these as “types of ingredients”
- Audience name
- Terms of art
- Community keywords
I want to use the unique ingredients from those tables in “recipes” uncover every possible combination of ingredients (within the constraints of each recipe, where order does matter):
- Audience name + terms of art + community keywords
- Audience name + products + community keywords
- Products + terms of art + community keywords
Ideally each unique string of ingredients produced by a recipe would populate as a row in another table. I’d also love to be able to easily come up with new recipes and produce strings from them as needed in the future.
Has anyone built something like this, or could you give me some pointers with where to start? I’m already questioning if having all my ingredients in separate tables is over-complicating this; perhaps they ought to all be in one table with another column that handles “type” (which is currently their table name).