s

Tables (9)

instrument

  • instrument_id — BIGINT — Primary key — NOT NULL
  • symbol — VARCHAR(32) — 티커/키 (예: AAPL, 005930.KS)
  • ui_label — VARCHAR(100) — NOT NULL — UI 표시명 (예: A 뷰티)
  • name — VARCHAR(255) — NOT NULL
  • currency_code — CHAR(3) — NOT NULL — USD/KRW 등
  • exchange_code — VARCHAR(16) — NOT NULL — NASDAQ/KRX 등

orders

  • order_id — BIGINT — Primary key — NOT NULL
  • round_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • instrument_id — BIGINT — NOT NULL
  • side — ENUM('BUY', 'SELL') — NOT NULL
  • order_type — ENUM('MARKET', 'LIMIT') — NOT NULL
  • status — ENUM('NEW', 'FILLED', 'CANCELLED', 'REJECTED') — NOT NULL
  • qty — DECIMAL(18, 4) — 수량 기반이면 사용
  • amount — DECIMAL(18, 2) — 금액 기반이면 사용(택1 운영)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

room

  • room_id — BIGINT — Primary key — NOT NULL
  • invite_code — VARCHAR(32) — NOT NULL — 초대 코드
  • pwd — VARCHAR(255) — 비공개 방 비번(옵션)
  • seed_money — DECIMAL(18, 2) — NOT NULL — 팀 기본 시드머니
  • start_year — INT — NOT NULL — 시작 연도 (예: 2000)
  • max_rounds — INT — NOT NULL — 라운드 수
  • max_member — INT — NOT NULL
  • max_team — INT — NOT NULL
  • mode — ENUM('STANDARD', 'RELAXED') — NOT NULL
  • status — ENUM('OPEN', 'IN_PROGRESS', 'ENDED') — NOT NULL
  • owner_user_id — BIGINT — NOT NULL — 방 개설자
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

round

  • round_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • round_no — INT — NOT NULL — 1..N
  • year — INT — NOT NULL — 해당 라운드의 연도
  • hint_text — TEXT — 시대적 힌트

round_return

  • round_id — BIGINT — Primary key — NOT NULL
  • instrument_id — BIGINT — Primary key — NOT NULL
  • pct_return — DECIMAL(6, 3) — NOT NULL — 라운드 수익률 % (예: 5.250)

team

  • team_id — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — NOT NULL
  • team_name — VARCHAR(100) — NOT NULL
  • is_ready — TINYINT(1) — NOT NULL
  • cash_balance — DECIMAL(18, 2) — NOT NULL — 현재 현금
  • asset_value — DECIMAL(18, 2) — NOT NULL — 총자산(현금+보유평가)
  • final_rank — INT — 게임 종료 시 순위

team_member

  • team_member_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • room_id — BIGINT — NOT NULL
  • is_leader — TINYINT(1) — NOT NULL
  • is_ready — TINYINT(1) — NOT NULL

team_round

  • team_round_id — BIGINT — Primary key — NOT NULL
  • round_id — BIGINT — NOT NULL
  • team_id — BIGINT — NOT NULL
  • hint_used_cnt — INT — NOT NULL
  • hint_cost_sum — DECIMAL(18, 2) — NOT NULL
  • cash_after — DECIMAL(18, 2) — NOT NULL — 라운드 종료 후 현금
  • asset_after — DECIMAL(18, 2) — NOT NULL — 라운드 종료 후 총자산
  • note — VARCHAR(255)

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • provider — ENUM('KAKAO', 'GOOGLE', 'LOCAL') — 소셜 로그인 공급자
  • nickname — VARCHAR(100)
  • created_at — DATETIME
  • updated_at — DATETIME