I'm trying to design a DB to facilitate a fairly simple website system.
Basically a user can login and ask a 1-to-1 question of an expert. The expert logs in and sees the message and replies. The original message and the replies appear downwards on the screen, almost exactly like a thread in this forum works, except it's a 1-to-1 conversation and not something anyone else can view or contribute to. A private messaging system of sorts.
The expert can also, if they want to, write notes beside each question, but these are only viewable by the expert, the person asking won't see the expert's notes.
So, my thoughts were, for the message part of the DB (the user tables I'm happy enough with, they're already created) is to have something like:
I'll also have a Notes table that will have the MsgID and the NoteContent so that the note can appear beside the relevant message.
But I don't know if the above is enough to create the system as I've described.
Can anyone spot any huge flaws? I was thinking the messages would display by dateAdded but I've no idea how to keep note of which message relates to which, as in which is a reply to which and so on.