Or just go full double entry and allow multiple accounts per transaction, which is what anyone with an accounting degree would tell you to do. The bonus of doi

Or just go full double entry and allow multiple accounts per transaction, which is what anyone with an accounting degree would tell you to do. The bonus of doing it this way, everyone with an accounting degree won't gasp in horror when they understand what it is you did. The events table in your example is basically the same as a transaction table and dump the transaction_id into the ledger table. The bonus of doing it with a 'transaction_id' is accountants, auditors and the rest won't be confused.