coing

Tables (9)

bookmark (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → user.id — NOT NULL
  • item_id (Key3) — Foreign key → item.id — NOT NULL

candle (캔들)

  • id (Key) — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → item.id — NOT NULL
  • code (거래쌍)
  • start_price (시가)
  • end_price (종가)
  • high_price (고가)
  • low_price (저가)
  • acc_price (누적 거래 금액)
  • acc_volume (누적 거래량)
  • timestamp ((끝)시각) — Long
  • type (타입) — String
  • unit (단위)

item (종목)

  • id (Key) — Primary key — NOT NULL
  • code (거래쌍)
  • warning (유의여부) — Boolean
  • day_volume (24시간 거래량)
  • cap (시가총액)
  • dominance (도미넌스)

orderbook (호가)

  • id (Key) — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → item.id — NOT NULL
  • code (거래쌍)
  • timestamp (시각) — Long
  • ask_bid (구분)
  • level (단위)
  • total_ask_size (총매도량)
  • total_bid_size (총매수량)

orderbook_units (호가유닛)

  • id (Key) — Primary key — NOT NULL
  • orderbook_id (Key2) — Foreign key → orderbook.id — NOT NULL
  • ask_price (매도가)
  • ask_size (매도량)
  • bid_price (매수가)
  • bid_size (매수량)

refresh_token (리프레시토큰)

  • user_id (Key) — Foreign key → user.id — NOT NULL
  • token (토큰 값)
  • expiredAt (만료일)

role (권한)

  • user_id (Key) — Foreign key → user.id — NOT NULL
  • role (권한) — String

trade (체결)

  • id (Key) — Primary key — NOT NULL
  • item_id (Key2) — Foreign key → item.id — NOT NULL
  • code (거래쌍)
  • price (가격)
  • volume (수량)
  • change_price (전일대비)
  • timestamp (시각) — Long
  • ask_bid (구분) — String

user (유저)

  • id (Key) — Primary key — NOT NULL
  • name (이름)
  • email (이메일)
  • pwd (비밀번호)
  • createdAt (생성일)