I´m opening a Pet Shop that will also offer services for dogs and cats (grooming, training, exercises, walks, boarding). I need a data base that allows me to have a record for each dog or cat. That record should contain all the information related to it: picture, owners, emails, mobiles numbers, clinic story, amount of food per month, last vaccination, date of birth, services given by our store and frequencies, etc.
It should also be able to combine different fields and send email and mobile alerts to each of the dog or cat owners for. For example, a dog name Bruce eats 40 pounds of Royal Canin per month. The last purchase was 25 days ago. The system would automatically send a personalized reminder to Bruce´s owner telling them that they will probably be about to run out of food and asking them if they wish us to send them a new package.
The data base should be able to be accesed from different places (in the case a second store is opened, it should allow to enter the code of the store), and each user entering data should also be identified (for controling reasons)
I have organized the structure (attached). Is in Spanish, and it may need to re organize some items in order to improve the performance. But it pretty much contains everything I need.