Geek Answers Handbook

Messaging Application Database Schema

In my messaging application, the features I want to provide are as follows:

  • Sending a message to multiple users
  • Receive a message sent to the user
  • Displaying a message in groups separated by users, Like in a facebook message
  • But when a user sends a message to several people, it will not be a group message, but these messages will be sent to groups separated by users

My database schema is this: My database schema

This scheme can provide all the functions above, but receiving messages from this scheme in user groups is very difficult. Can anyone suggest me a better circuit?

An unnamed table has a display of recipients, forgot to write the name in jpg .: (

+8
database database-design database-connection
source share
1 answer

What is wrong with one table?

message_id timestamp in of the subject body attachment_pointer origin

...

I’m probably going to beat, but ... Affairs> hmm ... good point

Messages message_id timestamp subject body attachment MessageReference mr_id message_id to from

edit: The following are also found:

Messaging database schema

messaging database schema diagram

How do I set up my database schema for a messaging system complete with attachments?

Database schema for multi-user messaging

+5
source share

More articles:


All Articles