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