i have to design a database which should manage a website's internal mail system with every user's own inbox/outbox. how should i store the mails themselves and how can i store, which mail is in which user's in- or outbox, as an outgoing mail is someone else's incoming mail and vice versa (one mail is in someone's inbox && someone else's outbox).
i think that's a rather complex data structure...and as i am new to database design - perhaps someone can give me a clue. i thank you all....
wolfgang