야구퀴즈
테이블 (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