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