I am finding it sort of daunting working with Notification to make it work like facebook.
This is what I have:
memberId int --member id of the person causing the action
memberId --id of the member seen this notificationid
I did take a look at the schema how facebook is doing it. apparently they seem to be saving the entire message in html/plain text format.
If i look at linkedin, they seem to save notifications for different parts of the website in different tables. for groups, profile etc.
i am trying to have something that will allow me save minimal amount of data on database tables.
anybody got suggestions?