upbit

Tables (5)

candle

  • candle_id — PK — Primary key — NOT NULL
  • candle_time — TIMESTAMP
  • open — NUMERIC
  • high — NUMERIC
  • low — NUMERIC
  • close — NUMERIC
  • volume — NUMERIC
  • market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL

market

  • market_id — Primary key — NOT NULL
  • market_code — VARCHAR(20)
  • korean_name — VARCHAR(40)
  • english_name — VARCHAR(40)

quality_check

  • quality_id — PK — Primary key — NOT NULL
  • check_time — TIMESTAMP
  • table_name — VARCHAR(40)
  • result — VARCHAR(20)
  • details — TEXT

signal

  • sig_id — PK — Primary key — NOT NULL
  • market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL
  • signal_time — TIMESTAMP
  • signal_type — VARCHAR(20)
  • value — NUMERIC

trade

  • trade_id — PK — Primary key — NOT NULL
  • market_code — VARCHAR(20) — Foreign key → market.market_id — NOT NULL
  • trade_time — TIMESTAMP
  • price — NUMERIC
  • volume — NUMERIC
  • ask_bid — VARCHAR(10)
  • seq_id — BIGINT