야구퀴즈

테이블 (5)

퀴즈

  • quiz_id — BIGINT — 기본 키 — NOT NULL
  • question — TEXT — NOT NULL
  • option1 — VARCHAR(200) — NOT NULL
  • option2 — VARCHAR(200) — NOT NULL
  • option3 — VARCHAR(200)
  • option4 — VARCHAR(200)
  • correct_answer — INT — NOT NULL
  • explanation — TEXT
  • difficulty — ENUM('EASY', 'NORMAL', 'HARD')
  • score — INT
  • image_url — VARCHAR(500)
  • is_active — BOOLEAN
  • created_by — BIGINT
  • created_date — DATETIME
  • updated_date — DATETIME
  • category_id — BIGINT — 외래 키 → 퀴즈카테고리.category_id — NOT NULL

퀴즈결과

  • result_id — BIGINT — 기본 키 — NOT NULL
  • selected_answer — INT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • score_earned — INT
  • solve_time — INT
  • solved_date — DATETIME
  • member_id (member_id2) — BIGINT — 외래 키 → 회원.member_id — NOT NULL
  • quiz_id (quiz_id2) — BIGINT — 외래 키 → 퀴즈.quiz_id — NOT NULL

퀴즈카테고리

  • category_id — BIGINT — 기본 키 — NOT NULL
  • category_name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • is_active — BOOLEAN
  • created_date — DATETIME

회원

  • member_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_date — DATETIME
  • updated_date — DATETIME
  • refresh_token — TEXT
  • is_active — BOOLEAN

회원상세

  • member_id — BIGINT — 외래 키 → 회원.member_id — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(500)
  • birth_date — DATE
  • gender — ENUM('M', 'F', 'OTHER')
  • favorite_team — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • total_score — INT
  • quiz_count — INT
  • correct_count — INT
  • level — INT
  • created_date — DATETIME
  • updated_date — DATETIME