한번해voca

테이블 (8)

CATEGORY

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL

GAME_PARTICIPANT

  • id — BIGINT
  • room_id — BIGINT — 외래 키 → GAME_ROOM.id — NOT NULL
  • user_id — BIGINT — NOT NULL
  • final_score — INT
  • is_winner — BOOLEAN
  • contribution_score — INT — 레이드 기여도

GAME_ROOM

  • id — BIGINT
  • room_type — VARCHAR(20) — 1VS1, RAID
  • status — VARCHAR(20)
  • created_at — DATETIME

QUIZ_DETAIL

  • id — BIGINT
  • quiz_id — BIGINT — 외래 키 → QUIZ_LOG.id — NOT NULL
  • word_id — BIGINT — 외래 키 → WORD.id — NOT NULL
  • is_correct — BOOLEAN
  • user_answer — VARCHAR(255)

QUIZ_LOG

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → USER.id — NOT NULL
  • quiz_type — VARCHAR(50) — 진단, 일반, 복습 등
  • score — INT
  • total_count — INT
  • created_at — DATETIME

USER

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL — 로그인 ID
  • password — VARCHAR(255) — NOT NULL — 해싱된 비밀번호
  • role — VARCHAR(20) — NOT NULL — ADMIN, USER
  • nickname — VARCHAR(50) — NOT NULL
  • level — INT
  • tier — VARCHAR(20)
  • exp — INT
  • daily_quota — INT — 일일 학습 목표량
  • initial_level — INT — 초기 진단 레벨

USER_WORD

  • id — BIGINT
  • user_id — BIGINT — 외래 키 → USER.id — NOT NULL
  • word_id — BIGINT — 외래 키 → WORD.id — NOT NULL
  • weight — FLOAT — 복습 가중치
  • next_review_at — DATETIME — 차기 복습 예정일
  • last_reviewed_at — DATETIME — 최근 학습일
  • wrong_count — INT — 오답 횟수
  • correct_count — INT
  • consecutive_correct_count — INT — 연속 정답 횟수
  • status — VARCHAR(20) — STUDYING, MASTERED

WORD

  • id — BIGINT
  • category_id — BIGINT — 외래 키 → CATEGORY.id
  • spelling — VARCHAR(100) — NOT NULL
  • meaning — VARCHAR(255) — NOT NULL
  • example — TEXT
  • image_url — VARCHAR(500)
  • hint — VARCHAR(255)