dinance

테이블 (10)

refresh_token

  • token — CHAR(64) — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • expired_date — DATETIME
  • created_at — TIMESTAMP

거래 (trades)

  • trade_id — BIGINT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • market_id — BIGINT — 외래 키 → 쌍.market_id
  • price — DECIMAL(30, 10) — NOT NULL
  • quantity — DECIMAL(30, 10) — NOT NULL
  • type — ENUM('BUY', 'SELL') — NOT NULL
  • buy_order_id — BIGINT
  • sell_order_id — BIGINT
  • traded_time — TIMESTAMP — NOT NULL

로그인 히스토리 (login_history)

  • login_id — INT — 기본 키
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(255)
  • success — BOOLEAN — NOT NULL
  • reason — VARCHAR(255)
  • login_time — TIMESTAMP

마켓 자산 (BTC/USDT (마켓)) (assets)

  • market_id — BIGINT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • amount — DECIMAL(30, 10) — NOT NULL
  • updated_at — TIMESTAMP

쌍 (markets)

  • market_id — BIGINT — 기본 키 — NOT NULL
  • base_asset — VARCHAR(20) — NOT NULL
  • quote_asset — VARCHAR(20) — NOT NULL
  • status — ENUM('ACTIVE', 'INACTIVE')
  • created_at — TIMESTAMP

유저 (user)

  • user_id — INT — 기본 키 — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • name — VARCHAR(30)
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

유저 지갑 (BTC, USDT, ETH (단일) (user_wallets)

  • wallet_id — BIGINT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • asset — VARCHAR(20) — NOT NULL
  • balance — DECIMAL(30, 10) — NOT NULL
  • updated_at — TIMESTAMP

주문 (orders)

  • order_id — BIGINT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → 유저.user_id — NOT NULL
  • market_id — BIGINT — 외래 키 → 쌍.market_id
  • type — ENUM('BUY', 'SELL') — NOT NULL
  • price — DECIMAL(30, 10)
  • quantity — DECIMAL(30, 10) — NOT NULL
  • status — ENUM('NEW', 'FILLED', 'CANCELLED') — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

캔들차트 (ohlcv)

  • candle_id — BIGINT — 기본 키
  • market_id — BIGINT — 외래 키 → 쌍.market_id
  • interval — ENUM('1m', '5m', '15m', '1h', '1d') — NOT NULL
  • open_price — DECIMAL(30, 10)
  • high_price — DECIMAL(30, 10)
  • low_price — DECIMAL(30, 10)
  • close_price — DECIMAL(30, 10)
  • total_trade_volume — DECIMAL(30, 10)
  • total_trade_price — BIGINT
  • created_at — TIMESTAMP
  • open_time — TIMESTAMP
  • close_time — TIMESTAMP

코인목록 (coin)

  • coin_id — INT — 기본 키 — NOT NULL
  • market_id (market) — VARCHAR(10) — NOT NULL
  • price — DECIMAL(30,10)
  • amount — DECIMAL(30,10)
  • time — TIMESTAMP