I'm creating a statistics system for events. When an event has passed,
an admin can enter statistics for that passed event. Every user
attending the event and the event itself have statistics. The problem
is that depending on the type of the event, the type of statistics for
both users and event can change. eg: for one event the number of
remarks and time present will be registered for another event the name
of the company he represents
I'm struggling on how to implement this especially database wise. I
can ofcourse create a table that contains all possible statistics data
and than only fill in the rows that matter for that event. the
downside is that I lose a lot of storage since a lot of rows are left
maybe someone has an idea on how to solve this?
thanks in advance.