Wednesday, August 28, 2013

How to do a clear database design

How to do a clear database design

I'm designing a database.
On my system, users can do this:
Sent message to other users with text and/or files (images, videos, etc.)
Sent a friendship request to other users without any text.
I thought that messages and friendship request are the same (a friendship
request is a type of message):

But, I think I can split that table into two tables, to make my model more
clear:

What is your opinion? One or two tables?

No comments:

Post a Comment