TinerPay

Balances de un usuario activo — usa el índice wallets(user_id).

SELECT w.balance, w.currency_code
FROM wallets w
JOIN users u ON w.user_id = u.id
WHERE u.email = 'diego@gmail.com'
AND u.deleted_at IS NULL;

Historial de envíos de una wallet — usa el índice transactions(from_wallet).

SELECT t.amount, t.created_at
FROM transactions t
WHERE t.from_wallet = 'uuid-wallet-origen'
ORDER BY t.created_at DESC;

Historial de recepciones de una wallet — usa el índice transactions(to_wallet).

SELECT t.amount, t.created_at
FROM transactions t
WHERE t.to_wallet = 'uuid-wallet-destino'
ORDER BY t.created_at DESC;

Wallets por divisa — usa el índice wallets(currency_code).

SELECT w.id, w.balance, u.name
FROM wallets w
JOIN users u ON w.user_id = u.id
WHERE w.currency_code = 'EUR'
AND u.deleted_at IS NULL;

JOIN con users en la propia query — solo actualiza wallets de usuarios activos.

UPDATE wallets w
SET balance = balance + 100
FROM users u
WHERE w.user_id = u.id
AND u.email = 'diego@gmail.com'
AND u.deleted_at IS NULL;

Soft delete — marcamos deleted_at en lugar de borrar, preservando el historial financiero completo.

UPDATE users
SET deleted_at = now()
WHERE email = 'diego@gmail.com'
AND deleted_at IS NULL;