search for: db_transact

I''m building a system where every change made to the database has to auditable. Every time a change is made I store a timestamp, a user id, and description of the transaction in a db_transactions table. Every other table has a transaction_id field that references what transaction last created or updated it. How I handle updates now is have a DbTransactions model that contains has_many relationships to all other tables. I create a DbTransaction, add whatever records I am creating or...