I'm designing a database for a new project and I'm looking for some feedback on the design before I start to implement. It basically consists of secure messaging system with those abilities :

  • One user can send a message to one or many users
  • Messages can be sent both to registered and unregistred users
  • User can be a person or a company
  • A company can have multiple user but only one administrator

1°) I am having difficulties with choosing how to approach the relashionship between Messages and User and particularly how to manage unregistred users.

2°) Is the relationship between User and userGroup a good approach for multi-users ?

database design

I will appreciate any feedback given :) Many thanks ! and sorry for my english...

  • You need to tune your db design please check the link below it will give you an idea on how messaging schema design . good luck :) 9lessons.info/2013/05/message-conversation-database-design.html – user32391 Jan 4 '14 at 9:19
  • @user32391, the model you are refering to is single-single user chat, the design of the TS is based on multi user chat. In my honest opinion something which you should take account into these days. – Mario Feb 7 '18 at 7:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.