Ask HN: How to model daily state of accounts in RDBMS?
I'm writing a module to handle accounting data for our company. We need to be able to see what the state of accounts (payables/receivables) were on any given day. How do I model this in an RDBMS?
I'm very new to database design.