# Database notes
- SQLite file: `on1builder.db` (configurable via `DATABASE_URL`).
- Migrations: `migrations/20260113000000_init.sql` (applied automatically via `sqlx::migrate!`).
## Tables
- `transactions`: tx_hash (unique), chain_id, from/to, value_wei, gas_used/price, status, strategy, timestamps.
- `profit_records`: tx_hash, chain_id, strategy, profit_eth, gas_cost_eth, net_profit_eth, timestamp.
- `market_prices`: chain_id, symbol, price_usd, source, timestamp.
- `_sqlx_migrations`: migration metadata.
## Quick inspection
You can view the schema and row counts with:
```bash
python3 - <<'PY'
import sqlite3
conn = sqlite3.connect("on1builder.db")
cur = conn.cursor()
cur.execute("SELECT name FROM sqlite_master WHERE type='table'")
tables = [r[0] for r in cur.fetchall()]
print("Tables:", tables)
for t in tables:
cur.execute(f"PRAGMA table_info({t})")
print("\\nSchema for", t)
for col in cur.fetchall():
print(col)
cur.execute(f"SELECT COUNT(*) FROM {t}")
print("Row count:", cur.fetchone()[0])
conn.close()
PY
```