motoo
Tables (6)
Account (Untitled)
- accountId (Key) — Primary key — NOT NULL
- email (Field)
- password (Field2)
Member (Untitled2)
- memberId (Key) — Primary key — NOT NULL
- memberType (Field)
- name (Field2)
- accountId (Key2) — Foreign key → Account.accountId — NOT NULL
Order (Untitled8)
- orderId (Key) — Primary key — NOT NULL
- memberId (Field2)
- coinSymbol (Field)
- orderType (Field3)
- price (Field4)
- quantity (Field5)
- status (Field6)
- memberId (Key4) — Foreign key → Member.memberId — NOT NULL
Trade (Untitled5)
- tradeId (Key) — Primary key — NOT NULL
- orderId (Key2) — Foreign key → Order.orderId — NOT NULL
- buyOrderId (Field)
- sellOrderId (Field2)
- coinSymbol (Field3)
- price (Field4)
- quantity (Field5)
- createdAt (Field6)
Transfer (Untitled7)
- transferId (Key) — Primary key — NOT NULL
- fromMemberId (Field)
- toMemberId (Field2)
- coinSymbol (Field3)
- quantity (Field4)
Wallet (Untitled6)
- walletId (Key) — Primary key — NOT NULL
- coinSymbol (String)
- quantity (..)
- memberId (Key2) — Foreign key → Member.memberId — NOT NULL