We are currently developing a product in the AWS environment that requires instantaneous data consistency for DB transactions that span multiple schemas in a Aurora postgres instance. Each schema will be updated by a service/micro-service/lambda orchestrated through step function workflow.
What is the best way to model transactional system with a need to read holding/balance?
I have a data model that is similar to the bank transactions. Simplified version looks like this: