I am starting a personal project for my apprenticeship, an application simulating a financial institution system, I would first use the following products: checking account, credit agreement (loans). I came across the following difficulty, what would be the best way to model the current account balances daily and the same goes for the credit product?
Currently this would be the current account table:
id_cliente - inteiro, fk
num_conta - inteiro
tipo_conta - inteiro, fk
situacao_conta - inteiro, fk
data_abertura - data
data_encerramento - data
I thought about creating a balance_cc table and storing the balance and date account number, would that be a good idea?