I am writing to ask for advice from more experts on how to better manage a database useful for creating an app that manages events.
I have made several attempts, but many things do not add up to me.
In practice what I need would be:
Creation of different EVENTS in different locations.
Each user can participate in multiple events at the same time, so each event will have its own list of participants.
Each user can dedicate whether or not to participate in the proposed events, and if he decides to participate he can access a dedicated section (one for each event)
Each event will have a dedicated chat inside it. (so the events must be separated from each other)
How can I build a solid db that keeps inside:
EVENTS - USER - RELATIONSHIP BETWEEN USERS / EVENTS
As it will be important that each user (user login) when SELECTING “Yes participated” and enters the dedicated section, can view the list of participants who, like him, have chosen to participate in that event (only that, not the others) .
Can anyone give me a hand or some advice on how to manage collections and relationships?
As I have done various experiments using two collections “User” and “Event” by putting various fields in relationship with each other such as “Participant user mail”, but I think this is not enough, because I have encountered various problems in showing the list (to the logged user) of the participants participating in that specific event. Or hiding various buttons from the non-participating user.
I believe it will be necessary to create a third collection, which keeps a record for each user who participates in an event. Am I wrong?
I’m doing something wrong, so I’m asking for your help.