Hi Dave, What are the requirements for the messages regarding: 1) deletion by either the sender or the receiver? For example: the sender deletes the message, but the message must still be viewable by the receiver! 2) multiple receivers? For example: to a group, do each group member get the message or only the group itself?
Enjoy, John On Jul 14, 9:30 pm, "Dave Maharaj :: WidePixels.com" <[email protected]> wrote: > I was curious how to approach this idea. > > A user can send a message to another user but how would you define the > table? > > id > user_id => person receiving > from_id =>person sending > title > message > created > > user hasMany messages but how would you determine that both users get the > message? > > Would you need to query where user_id OR from_id => $currentUserId to get > all messages related to that user? > > Dave --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
