코딩 학습 기록 서비스

테이블 (8)

attachments (첨부/S3 메타)

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • problem_id — BIGINT
  • record_id — BIGINT
  • s3_key — VARCHAR(1024) — NOT NULL
  • mime — VARCHAR(128)
  • size_bytes — BIGINT
  • created_at — TIMESTAMP(3) — NOT NULL

notification_log (알림 멱등/중복 방지)

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • channel — VARCHAR(16) — NOT NULL
  • due_at — DATETIME(3) — NOT NULL — UTC
  • delivered_at — DATETIME(3) — UTC
  • payload_json — JSON
  • created_at — TIMESTAMP(3) — NOT NULL

problem_tags (문제–태그 M:N)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • problem_id — BIGINT — 기본 키 — NOT NULL
  • tag_id — BIGINT — 기본 키 — NOT NULL

problems (문제)

  • problems_id — 기본 키 — NOT NULL
  • title — VARCHAR(300) — NOT NULL
  • source_url — VARCHAR(1000)
  • difficulty — VARCHAR(16) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • memo — TEXT
  • bookmarked — TINYINT(1) — NOT NULL
  • next_review_at — DATETIME(3) — UTC
  • visibility — VARCHAR(16) — NOT NULL
  • created_at — TIMESTAMP(3) — NOT NULL
  • updated_at — TIMESTAMP(3) — NOT NULL
  • FULLTEXT — KEY
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL

stats_monthly (월 집계)

  • month_date — DATE — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • solved_cnt — INT — NOT NULL
  • unsolved_cnt — INT — NOT NULL
  • review_needed_cnt — INT — NOT NULL
  • per_tag_json — JSON
  • updated_at — TIMESTAMP(3) — NOT NULL

study_records (학습 기록 히스토리)

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • problem_id — BIGINT — NOT NULL
  • title_opt — VARCHAR(300)
  • content_markdown — MEDIUMTEXT
  • code_lang — VARCHAR(32)
  • code_text — MEDIUMTEXT
  • created_at — TIMESTAMP(3) — NOT NULL
  • updated_at — TIMESTAMP(3) — NOT NULL

tags (태그)

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • created_at — TIMESTAMP(3) — NOT NULL

users (회원)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP(3) — NOT NULL
  • updated_at — TIMESTAMP(3) — NOT NULL