Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 :) 9lessons.info/2013/05/message-conversation-database-design.html –  mambo Jan 4 at 9:19
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.