코딩 학습 기록 서비스
테이블 (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