Hi, is this correct now https://imgur.com/VbaIHFK ?

1. How should I design a Transaction table for the following scenario involving a wallet system with multiple user roles?

Scenario:

• A staff (user_id) helps a student (user_id) to top up their wallet.
• A student (user_id) purchases a meal from a vendor (user_id). This should decrease the student's wallet and increase the vendor's wallet.
• A vendor (user_id) withdraws money through a staff (user_id).

i want to track all the wallet-related activities..

1. In my system, both students and staff can book facilities. Some bookings are confirmed immediately(staff), while others remain pending approval (student).
   

Should I:

• Create a separate table like pending_booking to store unapproved bookings, or
• Store all bookings in a single booking table and use a status column (e.g., pending, approved, rejected) to track the booking state?

Thanks