3 ms·

This is just the ledger table. In your case you would have a payment event table with one row and a join table that connects that event with all the ledger rows

• zie 4y ago
  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.