Query

mira.db — transactions

SQL

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())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
user_id TEXT Rename | Drop
scanned_by TEXT Rename | Drop
amount INTEGER Rename | Drop
created_at INTEGER Rename | Drop

Foreign Keys

Column Destination
scanned_by users.id
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_transactions_user
  • user_id
  • created_at
 SQL 
CREATE INDEX idx_transactions_user
ON transactions(user_id, created_at DESC)
Drop
sqlite_autoindex_transactions_1 id ✓ SQL
-- no sql found --
 Drop