mockit1

Tables (12)

Candles

  • id — BIGINT — Primary key — 캔들 식별자
  • stock_code — VARCHAR(16) — NOT NULL — 주식 종목 코드
  • ts — TIMESTAMP — NOT NULL — 캔들 시간
  • open_price — DECIMAL(18, 4) — NOT NULL — 시가
  • high_price — DECIMAL(18, 4) — NOT NULL — 고가
  • low_price — DECIMAL(18, 4) — NOT NULL — 저가
  • close_price — DECIMAL(18, 4) — NOT NULL — 종가
  • volume — BIGINT — NOT NULL — 거래량

LearningProgress

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → Users.user_id — 사용자 식별자
  • step_id — BIGINT — NOT NULL
  • status — ENUM('LOCKED', 'ONGOING', 'DONE') — NOT NULL
  • done_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

LearningSteps

  • id — BIGINT — Primary key
  • step_title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • rule_json — JSON
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Orders

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → Users.user_id — 사용자 식별자
  • stock_code — VARCHAR(16) — NOT NULL
  • side — ENUM('BUY', 'SELL') — NOT NULL
  • type — ENUM('MARKET', 'LIMIT') — NOT NULL
  • price — DECIMAL(18, 4)
  • qty — DECIMAL(18, 0) — NOT NULL
  • filled_qty — DECIMAL(18, 0) — NOT NULL
  • status — ENUM('OPEN', 'PARTIAL', 'FILLED', 'CANCELED') — NOT NULL
  • client_order_id — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • filled_at — TIMESTAMP

PortfolioLedger

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → Users.user_id — 사용자 식별자
  • delta — DECIMAL(18, 4) — NOT NULL
  • reason — ENUM('DEPOSIT', 'WITHDRAW', 'TRADE', 'FEE', 'QUIZ_REWARD', 'MISSION_REWARD') — NOT NULL
  • ref_id — VARCHAR(64)
  • ts — TIMESTAMP — NOT NULL

Positions

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Users.user_id — 사용자 식별자
  • qty — DECIMAL(18, 0) — NOT NULL
  • avg_price — DECIMAL(18, 4) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • stock_code — VARCHAR(16) — NOT NULL

QuizAttempts

  • attempt_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → Users.user_id — 사용자 식별자
  • quiz_id — BIGINT — Foreign key → Quizzes.quiz_id
  • selected_option_id — BIGINT — 선택한 보기 옵션
  • is_correct — BOOLEAN — NOT NULL
  • rewarded — BOOLEAN — NOT NULL
  • attempted_at — TIMESTAMP — NOT NULL

QuizOptions

  • option_id — BIGINT — Primary key
  • quiz_id — BIGINT — Foreign key → Quizzes.quiz_id
  • option_text — VARCHAR(255) — NOT NULL
  • is_correct — BOOLEAN — NOT NULL

Quizzes

  • quiz_id — BIGINT — Primary key
  • question — TEXT — NOT NULL
  • reward_capital — DECIMAL(18, 4) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

Stocks

  • stock_id — BIGINT — Primary key — 주식 종목 식별자
  • stock_code — VARCHAR(16) — NOT NULL — 종목 코드
  • stock_name — VARCHAR(255) — NOT NULL — 종목명
  • created_at — TIMESTAMP — NOT NULL — 생성 시간
  • updated_at — TIMESTAMP — NOT NULL — 수정 시간

Trades

  • id — BIGINT — Primary key
  • order_id — BIGINT — NOT NULL
  • stock_code — VARCHAR(16) — NOT NULL
  • price — DECIMAL(18, 4) — NOT NULL
  • qty — DECIMAL(18, 0) — NOT NULL
  • ts — TIMESTAMP — NOT NULL

Users

  • user_id — BIGINT — Primary key — 사용자 식별자
  • username — VARCHAR(255) — NOT NULL — 사용자 이름
  • password — VARCHAR(255) — NOT NULL — 비밀번호
  • created_at — TIMESTAMP — NOT NULL — 생성 시간
  • updated_at — TIMESTAMP — NOT NULL — 수정 시간