models/Transaction.js

const pool = require('../config/db');

const Transaction = {
  create: async (user_id, type, amount, status, wallet_address) => {
    await pool.query('INSERT INTO transactions (user_id, type, amount, status, wallet_address) VALUES (?, ?, ?, ?, ?)', 
      [user_id, type, amount, status, wallet_address]);
  }
};

module.exports = Transaction;