Problem: users can't see fees on transaction history

[outerlook]

from specs:

View the paid fees amount in the transaction history and transaction details

plan:

• create transaction_events. This tracks any write operations on the network, and also offers details about the transaction fees
• wrap all fee collection points with an action to include a transaction event
• add some actions that permit listing and locating these transaction events
• See if we can replace get_last_transactions to source from this new table instead of the old one, but might not be good if it's absolutely needed that all past transactions get backfilled

[coderabbitai]

A summary of the changes CodeRabbit can apply:

• Implement transaction fee visibility by adding a new transaction_events table (026-transaction-events-schema.sql), adding helper and public query actions (record_transaction_event, get_transaction_events, get_transaction_event_by_txid, get_transaction_events_by_action) in 027-transaction-events-actions.sql, instrumenting seven fee-collecting actions to record events (create_streams, insert_records, insert_taxonomy, request_attestation, sepolia_bridge_tokens, ethereum_bridge_tokens, public_transfer), and adding an enhanced get_last_transactions_v2() with fee and exemption data in 028-get-last-transactions-v2.sql.

• Add a new transaction_events audit schema and related actions/views (internal/migrations/026-transaction-events-schema.sql, 027-transaction-events-actions.sql, 028-get-last-transactions-v2.sql) and update multiple existing migration actions (001-common-actions.sql, 003-primitive-insertion.sql, 004-composed-taxonomy.sql, 024-attestation-actions.sql, erc20-bridge/001-actions.sql, erc20-bridge/002-public-transfer-actions.sql) to call record_transaction_event so all write operations record fee, caller, recipient, block height and exemption status for queryable transaction history.

• ✅ Create PR with these edits
• 📋 Get copyable edits

[outerlook]

@MicBun @williamrusdyputra I'm adding this issue, but as I'm onboarding only now on this goal, can you check if it's aligned with what you planned?

[williamrusdyputra]

@MicBun @williamrusdyputra I'm adding this issue, but as I'm onboarding only now on this goal, can you check if it's aligned with what you planned?

yes, it's aligned. We need to keep the complete history for auditing etc.