What are the fields that need to take attention while design data model for Notification based applications?

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)

What specifically do you want to know? It sounds a bit like you want us to design your database for you?

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.