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 — 수정 시간