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