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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.