Hi I was wonder how I could implement a social network-like news feed. For example is John (my contact) changes his phone number or joins a group it should appear in my news feed.
I was thinking of using a table called Feed with two fields message and userIDFK. So when John changes his phone number a row will be stored as follows:
John has updated his profile, 1 (userID)
Then I could just read this table. However problems with designs is that specific information is not stored, like the new phone number or group joined. Although I could include that information in the message field, I would not be able to link to the particular group he joined without a groupID.