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