In the following database design, how can I mark an unread message, do we know who reads the message from either the sender or the receiver?
(i.e. when person X sends a message to person Y, the message will be marked as unread for person Y until person Y reads this message, but it was marked as read for person X because he sent the message).
Message
MESSAGE_COMMENT
USER
MESSAGE_TYPE
EDIT: The design seems to be incomplete.
Read, . , UserID MessageID. , , ReceiverID MessageId.
Read
, ReceiverID MessageID, .