Structuring database for multi-object "activity" and "following" functionalities
- by romaninsh
I am working on a web application which operate with different types of objects such as user, profiles, pages etc. All objects have unique object_id.
When objects interact it may produce "activity", such as user posting on the page or profile. Activity may be related to multiple objects through their object_id.
Users may also follow "objects" and…