Hi there
I am working on a web application there is a notification section in my web application that is user forums.
User can post in the forums and other user can reply to them.Users can view each other profile.If someone has posted answar on posted question that OP should get notifications(Similar like other Notification Applications like SitePoint.com,Facebook.com)
Any one has experience in designing such types of application.Please answar what data should I store in Primary Table and what data in foreign Key relationships?
Do I need to use any stored procedures or function or triggers in the MySQL?
Thanks in advance
(I am using MySQL+Java)