01-10-2019, 10:54 AM
Not really because that would require too much in your users table to work. If I were trying to do it simply in one table, I would do a table called events with one line per event and the columns
id
event
monday_time
monday_spaces
tuesday_time
tuesday_spaces
etc
That's not the most dynamic way of doing it, but it's the simplest to comprehend.
Then when you add dodgeball, you add the event, and the time/spaces for each day.
Then signups would go in another table called signups
id
event_id
user_id
day
Then you cross reference the two tables.
id
event
monday_time
monday_spaces
tuesday_time
tuesday_spaces
etc
That's not the most dynamic way of doing it, but it's the simplest to comprehend.
Then when you add dodgeball, you add the event, and the time/spaces for each day.
Then signups would go in another table called signups
id
event_id
user_id
day
Then you cross reference the two tables.