I need a database to store customer and orders they placed. The database should be able to see how many times the customer ordered. So I am thinking making 3 tables customer table with customer data. Order table with custom id and item in.finle table items which list the amount of order and the items.order I’d will connect the other to tables. Do you guy think this will allow me to search for customer and see how many times they have ordered. Also I need an query where I would be able to set a date, if the customer don’t order 7 days give an automatic message is that possible ? Thank u
I am in design process. I am trying to build this in iOS.what is the best app u guys think ? Thank u