I’m trying to plan out the database schema for a calendar project. The idea is that users can create events, RSVP for them, and have their attendance confirmed by the host.
Not sure if I used the relational arrows right, but here’s a diagram:
Would it be wiser to have events registered and events attended as separate tables? Or keep the registered (RSVP) table with a binary value changed on attendance? If I added additional data, such as the host rating the attendees, would it make even more sense to have two tables?
This is my first time designing something like this so please feel free to bring up any other holes or issues in it.