Database Schema

Tables

networks(id, chain_id, family, name, symbol, decimals, enabled, maintenance)
rpc_providers(id, network_id, url, priority, healthy, p95_ms, last_check)
tokens(id, network_id, contract, name, symbol, decimals, logo, verified, spam, risk)
transactions(id, hash, chain, network, wallet_address, type, "from", "to", asset,
             amount, fiat_value, network_fee, status, timestamp, metadata jsonb)
devices(id, platform, push_token, created_at)
watch_addresses(device_id, network, address)
scam_domains(domain, source, added_by, added_at)
risky_contracts(network, address, reason, severity)
dapps(id, name, domain, category, featured, risk)
feature_flags(key, enabled, rules jsonb)
admin_users(id, role, mfa)   admin_audit_log(admin_id, action, target, diff, at)

Forbidden data

• Seed phrases
• Private keys
• PINs
• Unencrypted keystores
• Signing material