The reservation deposit and final payment are to be paid separately

Question

I currently have a business scenario like this. I have a food ordering system where users can order meals online. Users can place orders online and pay a portion of the reservation fee before arriving at the store. Waiting for the user After arriving at the store, how to design the mysql database when making the final payment for the order?

Answer 1

Come as normal, generate an order, the order status will be paid, unpaid, plus a paid deposit, and the rest of the table will be as normal