blakestar Posted November 3, 2008 Share Posted November 3, 2008 We have close to 8000 members in our database currently. I would like to try and implement an alert/message system whereby which support can post a message/alert and ALL members can view it online in their account manager when they login to the site. My database design question: What would be the most efficient way to structure the database for this type of system? I would not want to post 8000 separate messages in a messages.table, but at the same time, some members may want to delete the message from their online.inbox and others may want to save it for an unknown amount of time in their online.inbox. Initially I thought about a design similar to the following (simple view). alerts (id,message,date,expires,active) alerts_delete (alertid,memberid) When a member doesnt want to see an alert message, the alertid & memberid is added to alerts_delete. Link to comment https://forums.phpfreaks.com/topic/131236-message-alert-system-design-opinions/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.