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