On Mar 17, 12:16 am, "Dave Maharaj :: WidePixels.com"
<[email protected]> wrote:
> How would you build a Table to handle messages from user to user? So user 27
> wants to send a message to user 56... when user 56 logins in he can see his
> message from user 27.
[snip]
I usually uses the following ER model
User --- is sender of 0..* -> Message
User --- has corresponded 0..* -> Correspondence
Message --- is part of 1..* -> Correspondence
So three tables: User, Message and Correspondence
Hope this is useful to you, enjoy :)
John, LV
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
