Prisma schema question
How can I efficiently maintain a user's balance in a database given the following prisma schema, where the balance is the sum of all trades profitAndLoss? Should I store the balance as a field in the User model and update it manually or should I aggregate it from the Trade model on every request? How can I ensure that the balance stays up-to-date when old trades are removed or modified?
