Page 1 of 1

Design Structure for Notifications System

Posted: Tue Sep 29, 2009 9:28 am
by pws5068
I'm trying to redesign my motorist social networking site's notification system (concept similar to facebook's).

Currently, it stores messages like this:

Code: Select all

<a href="page.php?id=someID">UserName</a> commented on your <a href="vehiclePage.php?id=someID">VehicleName</a>
I Know this is redundant and poorly designed, so now I'm trying to decide the best way to do it.

My theory: (Just examples)

Code: Select all

 
{U:904} commented on your {V:201}
System Message: We are temporarily experiencing server issues.
{U:904} and {U:905} invited you to join the club {C:500}
 
I hope you can see why I cannot simply create columns for the obj ID, namely because of the last example which includes 3 dynamic links. With this design I could use regular expressions to rewrite the url and reduce redundancy.

Is this a practical design?

Re: Design Structure for Notifications System

Posted: Tue Sep 29, 2009 12:09 pm
by jackpf
Why not use something like bbcode?

Re: Design Structure for Notifications System

Posted: Thu Oct 01, 2009 3:30 am
by josh