I am currently working on a mobile app that lets you ask friends for favourites, it's a HTML5 frontend and a PHP backend. I am stuck as to what the best way is to build a notifications system, more-so the database schema than the actual code itself.The mobile application flow is as follows:
A User asks for a favour
The user can choose to; notify all friends, notify favourite friends or notifdy closeby friends
Depending on what the user chose, people are notified
What is the best way to do this in PHP and MySQL? I'm not really asking for anyone to write me the PHP code, but rather map out the most ideal MySQL table and fields schema instead as that is what I am currently stuck on. Thanks in advance for your help.
