COCKY

Tables (10)

ai_generation_log

  • round_id — BIGINT — Primary key — NOT NULL
  • id — BIGINT — Primary key — NOT NULL
  • problem_id — BIGINT — Foreign key — 생성 성공 시에만 채워짐, 실패면 NULL
  • sequence_no — TINYINT — NOT NULL — 9개 중 몇 번째 시도인지 (1~9)
  • status — ENUM('SUCCESS', 'FAILED') — NOT NULL
  • error_message — TEXT
  • retry_count — TINYINT — NOT NULL — 재시도 횟수
  • created_at — DATETIME — NOT NULL

feedback

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • period_type — ENUM('TWO_DAY', 'WEEKLY', 'MONTHLY') — NOT NULL
  • content — TEXT — NOT NULL
  • score — DECIMAL(5,2) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • created_at — DATETIME — NOT NULL

notification

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

problem

  • id — BIGINT — Primary key — NOT NULL
  • round_id — BIGINT — Foreign key → round.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • difficulty — VARCHAR(10) — NOT NULL
  • is_ai_generated — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • language — ENUM('PYTHON','C','JAVA')

ranking_snapshot

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • period_type — ENUM('TWO_DAY', 'WEEKLY', 'MONTHLY') — NOT NULL
  • scope_type — ENUM('SCHOOL', 'GRADE', 'CLASS_VS_CLASS', 'WITHIN_CLASS') — NOT NULL — 전교/학년/반대항전/반내
  • rank — INT — NOT NULL
  • score — DECIMAL(5, 2) — NOT NULL
  • calculated_at — DATETIME — NOT NULL
  • round_id — BIGINT — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • period_key — VARCHAR(20)

round

  • id — BIGINT — Primary key — NOT NULL
  • topic_id — BIGINT — Foreign key → topic.id — NOT NULL
  • round_date — DATE — NOT NULL
  • open_at — DATETIME — NOT NULL — 월/수/금 0시
  • close_at — DATETIME — NOT NULL — 화/목/토 0시
  • is_active — BOOLEAN — NOT NULL

submission

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user.id — NOT NULL
  • problem_id — BIGINT — Foreign key → problem.id — NOT NULL
  • code — TEXT — NOT NULL
  • verdict — ENUM('AC', 'WA', 'TLE', 'RE', 'CE', 'PENDING') — NOT NULL
  • score — DECIMAL(5, 2) — NOT NULL
  • is_latest — BOOLEAN — NOT NULL — 동일 (user, problem) 최신 제출만 TRUE - 랭킹 반영
  • submitted_at — DATETIME — NOT NULL

test_case

  • id — BIGINT — Primary key — NOT NULL
  • problem_id — BIGINT — Foreign key → problem.id — NOT NULL
  • input — TEXT — NOT NULL
  • expected_output — TEXT — NOT NULL
  • is_sample — BOOLEAN — NOT NULL — 공개 예시 여부

topic

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL — 예: 그리디, DP 등
  • week_order — TINYINT — NOT NULL — 8주 순환 순서 (1~8)

user

  • id — BIGINT — Primary key — NOT NULL
  • datagsm_id — BIGINT — NOT NULL — DataGSM 연동 계정
  • name — VARCHAR(50) — NOT NULL
  • grade — TINYINT — NOT NULL — 학년
  • class_no — TINYINT — NOT NULL — 반
  • role — ENUM('ADMIN', 'STUDENT') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • department — VARCHAR(20)
  • email — VARCHAR(100)
  • number — TINYINT
  • refresh_token — VARCHAR(512) — NOT NULL