I'm building a petition site and trying to figure out the best solution to use the collections. My site will have multiple different petitions, created by the users. So I think I'll need 1) one collection to store users profiles; 2) one collection to store the petitions.
But then I don't know the best way to store the data of what petitions each user signed. a) Should I create a new collection storing the petition names and the users who signed each one? Or this could result in a collection with too many columns to work with? b) Should I create an individual collection for each petition? But how can I do that automatically, as the petitions will be user generated?
c) Should I, instead of creating a third collection, build somehow a correlation between collection 1) and 2)? How? Consider that the data must be stored in a way that I can retrieve the information later and be able to communicate with users, example: send emails to everyone who signed an specific petition. Thank you in advance! Daniel