Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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...

share|improve this question
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 :) – user32391 Jan 4 '14 at 9:19

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.