Table design for storing email address
-
Hi All, I'm developing a knowledgebase system where in user can create his own knowledgebase by adding articles to different categories.The categories are in tree like structure where in each category node can contain articles and sub categories. I need to provide the user with the option of subscribing for these categories and whenever any changes are made to articles or any of the categories under it, the user should be notified via email. Can someone tell me how I can design the database to store these information and how can i determine the email address to be notified whenever any changes are made under the category for which user has subscribed. Thanks in advance Regards Raghu
-
Hi All, I'm developing a knowledgebase system where in user can create his own knowledgebase by adding articles to different categories.The categories are in tree like structure where in each category node can contain articles and sub categories. I need to provide the user with the option of subscribing for these categories and whenever any changes are made to articles or any of the categories under it, the user should be notified via email. Can someone tell me how I can design the database to store these information and how can i determine the email address to be notified whenever any changes are made under the category for which user has subscribed. Thanks in advance Regards Raghu
UserTable with UserID and Email address CategoryTable with CategoryID and UserID When a change to a category occures, you would search the CategoryTable for the CategoryIDs you want, get the associated UserIDs, then search the UserTable with the UserID to get the email addresses.