Database schema of messaging application
In my messaging application, The features I want to provide are:
- Sending a message to multiple people
- Receiving message sent to a user
- Showing message in groups divided by the users, Like in facebook message
- But when a user will send a message to multiple people, It will not be a group message but those messages will go in groups divided by users
My database schema is like this
This schema is able to provide all the functions above but getting the message out from this kind of schema in groups of users is very complex. Can anyone suggest me some better schema??
The unnamed table is of receivers mapping, forgot to write the name in jpg. :(
Solution
What is wrong with one table?
message_id timestamp to from subject body attachment_pointer origin
...
I'll probably get thrashed for it but... hmm...good point
Messages
message_id
timestamp
subject
body
attachment
MessageReference
mr_id
message_id
to
from
edit: Also found these:
Messaging system database schema
thread messaging system database schema design
How should I setup my database schema for a messaging system complete with attachments?
- What do you call a parent with no children?
- Error code 1005, SQL state HY000: Can't create table errno: 150
- TCP proxy to postgres database as an upstream server in nginx
- PDOException SQLSTATE[HY000] [2002] No such file or directory
- MySQL 8 create new user with password not working
- Relational Data Model for Double-Entry Accounting
- How to generate SQLite entity relationship diagram from database file
- Partially initialized module 'pyairtable'
- Unable to install SQL Server(setup.exe) Exit code decimal: -2061893606
- Database column encryption postgres
- Postgresql - backup database and restore on different owner?
- Getting some error with my test DB2 store procedure
- MySQL partitioning by week automatically
- How to initialize a database connection only once and reuse it in run-time in python?
- What's the easiest way to get a user's full name on a Linux/POSIX system?
- Magento SQL Queries
- Django: save() vs update() to update the database?
- What does "incremental load" mean?
- Select all for the last projetID entered
- Delphi XE5 FireDAC Error: Cannot load vendor library [libmysql.dll or libmysqld.dll]
- When should you use a one-to-one relationship with tables in your database?
- Would the following table containing two foreign keys also be the primary key for that table?
- Cassandra/Scylla Counters; What's the most common approach to tracking the count for emoji reactions?
- filter for a certain string in a certain column otherwise another string in another column
- Extracting labels from SPSS files in R
- The target table ... of DELETE is not updateable
- How to store the time offset given in a timestamptz literal?
- truncate all tables in laravel using eloquent
- Write an Effective query for django for a FOR Loop?
- Tool for convert SQL code to diagram