interview-task

Tables (3)

Untitled (wallets)

  • Key (id) — number — Primary key — NOT NULL
  • Key (userId) — number — Foreign key → users.Key — NOT NULL
  • Field (balance) — number — NOT NULL
  • Field (updatedAt) — Date — NOT NULL
  • Field (createdAt) — Date — NOT NULL

Untitled (transactions)

  • Key (id) — uuid — Primary key — NOT NULL
  • Key (walletId) — number — Foreign key → Untitled.Key — NOT NULL
  • Field (pgType) — enum — NOT NULL
  • Field (pgTransactionId) — string — NOT NULL
  • Field (amount) — number — NOT NULL
  • Field (currency) — number — NOT NULL
  • Field (isRollback) — boolean — NOT NULL
  • Field (updatedAt) — Date — NOT NULL
  • Field2 (createdAt) — Date — NOT NULL

users

  • Key (id) — number — Primary key — NOT NULL
  • Field (username) — string — NOT NULL
  • Field (password) — string — NOT NULL
  • Field (email) — string — NOT NULL
  • Field (isAdmin) — boolean — NOT NULL
  • Field (updatedAt) — Date — NOT NULL
  • Field (createdAt) — Date — NOT NULL