I have the following table design.
Event table, with helper tables to hold the event meta data.
each event row has an event type column (
timed_messages, and more.)
each event type has its own tables to define different things regarding the event - including users. The thing is that it might be referenced directly by a many to many table (
users_regular_events) or by a third table or forth table (
events -> recurring_routes -> recurring_routes_stations -> recurring_stations -> recurring_stations_users -> users).
would it make sense to create a
users_events table that duplicates relations between certain events? because, currently if I want to show each user his events I'll have to join multiple tables. Maybe I need to rethink my entire design?