The process of notifying subscribers through e-mails is far more complex compared to the notification procedure used earlier with the publishing of topics. Here, we need to cater to the following list of tasks to automate the notification sending:
- Add a notify status on new topic replies to identify new topics.
- Grab the new replies within the time interval using a notify status for replies.
- Get the list of subscribers for each topic.
- Send notifications to filtered subscribers.
First, we need a way to track the topics that have been already notified and those that are yet to be notified. Therefore, we will use the notify_status column value of the topic_replies table. We already assigned default value ...
