I am planning to develop an Event Planning Application. Currently I’m in the stage of planning the app structure, for example database schemas. Basically there will be two kinds of users:
The event planner: Has access to a dashboard, list of guests, etc.
The event guest: One guest is assigned to one event. Can login and answer questions, access photos from the event
Now my question: What is the best way to store the guests regarding security, scalability and maintainability. Is it ok to store all guests in one single database table ‘guests’ with a column ‘event_id’ or is it better to create a table for every event and have multiple tables with guests like ‘event_1_guests’, ‘event_2_guests’, and so on.