Database Design Question

Hi Guys

i have a question about cake compatible database design:

i have a table "mails" and a table "users"

my table mail references 2 users from the users-table as Sender,
Recipient

but then, i have 2 foreign keys in it, and i dont know how to handle
this properly
(or even name it correctly)

Anyone having an idea ? Or do i need a third table with the user,user-
>mail information...

greets
duderion

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en