Page 1 of 1

Mailing database design, how?

Posted: Mon Oct 27, 2008 4:16 am
by yoji
I am studying a bit about relational databases. I have got question: How can I save messages in database? Let's say there are hundred or so users using a mailing system. Now how are the messages of each individual saved in database? Is each user assigned a new table and each message gets a new row? I just want to know what should be the design of the database...

Re: Mailing database design, how?

Posted: Mon Oct 27, 2008 4:38 am
by onion2k
yoji wrote:I am studying a bit about relational databases.
In which case, shouldn't you be working this out yourself? You won't learn much if people just give you a solution.

I will give you a hint though ... definitely not one table per user. That would be a terrible idea.