Creating schema for the mail module. Two user flows: People message eachother onsite and eventually add in webamil functionality.
My tech team created the schema like Messages, Trash_messages, Inbox, Sent_message... where each table has message_id, sender, received, message_text, message_subject.
My view is to create only one message table and just state sender, receiver and which folder it is in, in that table itself. This way we dont have to move around the entire message from table to table as the user moves it from folder to folder.
Other issues is there other items like Priority, Attachments, etc. If we move messages around then we need to move these too. Plus users can create custom folders. So which design works best? Or maybe there is a better design out there?
Issue with my design is the table will grow super super large + 1 sender to multiple receivers wont work well, so I can normalize that portion to two tables.