Mainly want to know the next logical design, don't joke little brother problem superficial ha,
Just want to know the next app and the website of the message read, such as mass announcement, then the user did not read when the display is not read, after viewing the display has been read, then how to achieve?
If you use a single table to achieve, then each message has how many people read to add how many records, if 100,000 users, the monthly push 10, if all read it is not to add 1 million data ah, so the accumulation is too large, if all deleted then the user's mailbox will all show unread ... Younger brother foolish still hope the elder pointing under,
Reply to discussion (solution)
Status
0 or 1
Add a Lookup Time field
Status
0 or 1
The key is mass ah,
Add a Lookup Time field
Separate table records _log each user reads a record (message id+ time)?
Add a field Is_read = 0
If you've seen Is_read=1,
