igemoney_erd
Tables (7)
bookmark
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- quiz_id (Key3) — Foreign key → quiz.quiz_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL — 북마크한 날짜
column_article
- id — BIGINT — Primary key
- title — VARCHAR(200) — NOT NULL — 칼럼 제목
- content — LONGTEXT — NOT NULL — 본문 내용 (HTML 형태, 이미지 포함)
- thumbnail_image_url — VARCHAR(500) — 썸네일 이미지 S3 URL
- category — ENUM — NOT NULL — 칼럼 카테고리
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
quiz
- quiz_id (Key) — Primary key — NOT NULL
- topic_id — BIGINT — NOT NULL — 토픽 ID
- question_title — VARCHAR(200) — NOT NULL — 문제 제목 (퀴즈 목록용)
- question_type — ENUM('MULTIPLE_CHOICE', 'OX', 'SUBJECTIVE') — NOT NULL — 문제 유형
- question_data — JSON — NOT NULL — 선택지/정답 정보
- difficulty_level — ENUM('EASY', 'MEDIUM', 'HARD') — NOT NULL — 난이도
- explanation — TEXT — 해설
- question_order — INT — NOT NULL — 토픽 내 순서
- correct_rate — DECIMAL(5, 2) — 정답률 (0.00~100.00)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
quiz_topic
- id — BIGINT — Primary key
- name — VARCHAR(100) — NOT NULL — 토픽명 (경제기초, 투자기초 등)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_quiz_correct (정답 기록용 테이블)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- quiz_id (Key3) — Foreign key → quiz.quiz_id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
user_quiz_incorrect (오답기록 및 복습로직 활용 테이블)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → users.user_id — NOT NULL
- quiz_id (Key3) — Foreign key → quiz.quiz_id — NOT NULL
- next_review_date (review_date) — DATE — NOT NULL — 복습 예정일
- review_cycle — ENUM — NOT NULL — 복습 단계 (1, 2, 3)
- is_completed — BOOLEAN — NOT NULL — 복습 완료 여부
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
users
- user_id (Key) — Primary key — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- oauth_id — VARCHAR(100) — NOT NULL — 카카오 소셜 로그인 식별자
- rating_point — INT — NOT NULL — 레이팅 포인트
- consecutive_attendance_days — INT — NOT NULL — 연속 출석일수
- last_attendance_at (Field)
- today_solved_count (Field2)
- is_active — BOOLEAN — NOT NULL — 계정 활성 상태
- created_at — TIMESTAMP — NOT NULL