Hi all
I'm trying to figure out the best way to model a financial transaction history on a per-customer basis. Right now I have a user table and a transactions table. All transactions for all customers are currently in the transactions table.
I want to have a running available balance calculated for each customer as each transactions posts. What's the best way to achieve this? A single column in the user table called 'available balance' that is updated as each transaction is added to the transactions table?
Thanks.