There are two ways of doing that I can think about:
- Have a table for each activity type and store them there.
- Have a one big
activitiestable and store activities as JSON.
Both of those options seem to have some serious disadvantages, the former one makes it difficult to get all activities from one actor in the chronological order and is not very scalable, the latter one doesn’t allow me to know what actor created the activity and other data without parsing JSON first.
Is there a better way than using those two option? Or is there a way to “fix” disadvantages that I mentioned?