What is the best way to do user balance in laravel?

Question

Database design

Tell me, I want to make the user a balance in points and a history of points accrual / write-off, how best to make a separate table amount and amounthistory or make the amount field in the Users table. Maybe there is a similar solution?

Answer 1

make tables
accounts -> user_id, amount
accounts_history -> user_id, account_Id, date, amount (plus or minus if expense), description
you can make one to one - if the user has only one account
or one to many if there are many accounts.

Answer 2

There are ready ones, you just have to look.
The transaction history table is needed. And here's how to store the remainder in the user table or calculate it dynamically, it's up to you.