Hi there everyone,
The situation I'm asking about is like this:
There's hundreds of members from a game that have professions. These professions have hundreds of recipes. Each member will have only certain recipes. I'm trying to figure out the best way to store this information. I've come up with the following scenarios:
1) Each member with a particular profession gets their own row in a profession table with an array full of their recipes.
2) Each recipe gets a table with an array of members.
For retrieval, I can see needing both retrieving all members for a certain recipe and also all recipes for a certain member, but am pretty sure the latter will be the most common, as people will be viewing the recipes under a particular member when viewing their info page.
This will be the first time I've dealt with an undetermined number for both aspects (members and professions) of what I'm storing so I'm not sure how to both store and retrieve in such a situation.
Advice on how to handle this efficiently would be greatly appreciated!
