问题描述
鉴于下面的架构,如何合并通知系统?
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.
这篇关于通知系统设计的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!