codeflow
Tables (4)
problems
- id — BIGINT
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- difficulty — VARCHAR(20) — NOT NULL
- topic — VARCHAR(50) — NOT NULL
- language — VARCHAR(20) — NOT NULL
- test_cases — JSON — NOT NULL
- answer_code — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
submissions
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL
- code — TEXT — NOT NULL
- result — VARCHAR(20) — NOT NULL
- snapshots — JSON
- submitted_at — DATETIME — NOT NULL
user_progress
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- problem_id — BIGINT — Foreign key → problems.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- solve_count — INT — NOT NULL
- last_attempted_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- profile_image — VARCHAR(500)
- login_type — VARCHAR(20) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- email_verified — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL