Mailing database design, how?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
yoji
Forum Commoner
Posts: 25
Joined: Sun Oct 19, 2008 3:09 am

Mailing database design, how?

Post 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...
User avatar
onion2k
Jedi Mod
Posts: 5263
Joined: Tue Dec 21, 2004 5:03 pm
Location: usrlab.com

Re: Mailing database design, how?

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