通知系统设计 [英] Notification System Design

问题描述

鉴于下面的架构，如何合并通知系统?

Given the schema below, how can a notification system be incorporated?

当有人在其图片或SaleItem上发表评论以及有人对其SaleItem进行出价(通过购买要约")时，需要通知用户.

Users need to be notified when someone comments on their Picture or SaleItem along with when someone makes a bid on their SaleItem (through Purchase Offer).

最终目标是拥有一个可以处理SMS，电子邮件和内部系统消息传递系统的通知系统.这些选项的复杂性将得到解决，但是我需要可以基于它们的基本数据模型.

The ultimate goal is to have a notification system that will handle SMS, Email, and an internal system messaging system. The complexities of those options will be worked out but I need the basic data model from which they can be built upon.

MySql是正在使用的数据库，但我认为这不会影响数据模型.

MySql is the DB being used but I don't believe that should affect the data model.

谢谢

推荐答案

设置一个用于保存通知信息的表，并设置一个触发器，以便在系统中有任何操作时写入此表(让我们说新的出价)).

Setup up a table for holding the notification information and set up a trigger to write to this table whenever there is an an action in the system (lets say new bid).

然后您的调度程序应选择此新通知并发送电子邮件/短信.

then your scheduler should pick this new notification and sends email/sms.

这篇关于通知系统设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！