CREATE TABLE events (
  id             BIGSERIAL PRIMARY KEY,
  event_type     TEXT NOT NULL,
  occurred_at    TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  recorded_at    TIMESTAMPTZ NOT NULL DEFAULT NOW(),
  sats           BIGINT,
  fee_sats       BIGINT,
  fiat_amount    NUMERIC(18,2),
  fiat_currency  TEXT,
  from_wallet_id UUID REFERENCES wallets(id),
  to_wallet_id   UUID REFERENCES wallets(id),
  note           TEXT
);
--;;
CREATE INDEX idx_events_type ON events (event_type);
--;;
CREATE INDEX idx_events_occurred ON events (occurred_at);