Query

mira.db — transactions

Add Column

Cancel

Current Schema

CREATE TABLE transactions  (
  id          TEXT PRIMARY KEY,
  user_id     TEXT NOT NULL REFERENCES users(id),
  scanned_by  TEXT NOT NULL REFERENCES users(id),
  amount      INTEGER NOT NULL DEFAULT -1,
  created_at  INTEGER NOT NULL DEFAULT (unixepoch())
)