test

Tables (17)

ai_call_logs

  • id — BIGSERIAL — Primary key — NOT NULL
  • related_type — VARCHAR(20) — NOT NULL
  • related_id — BIGINT — NOT NULL
  • submission_id — UUID
  • status — VARCHAR(20) — NOT NULL
  • retry_count — SMALLINT — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL

ai_feedbacks

  • id — BIGSERIAL — Primary key — NOT NULL
  • code_explanation_id — BIGINT — Foreign key → code_explanations.id — NOT NULL
  • understood_concepts — JSONB — NOT NULL
  • weak_concepts — JSONB — NOT NULL
  • recommended_problem_id — BIGINT — Foreign key → problems.id
  • created_at — TIMESTAMP — NOT NULL

ai_followups

  • id — BIGSERIAL — Primary key — NOT NULL
  • code_explanation_id — BIGINT — Foreign key → code_explanations.id — NOT NULL
  • question_text — TEXT — NOT NULL
  • answer_text — TEXT
  • answered_at — TIMESTAMP

code_explanations

  • id — BIGSERIAL — Primary key — NOT NULL
  • submission_id — UUID — Foreign key → submissions.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • explanation_text — TEXT — NOT NULL
  • input_type — VARCHAR(10) — NOT NULL
  • attempt_no — SMALLINT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

daily_recommendations

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • problem_id — BIGINT — Foreign key → problems.id — NOT NULL
  • recommended_date — DATE — NOT NULL
  • reason — VARCHAR(30)

hint_steps

  • id — BIGSERIAL — Primary key — NOT NULL
  • submission_id — UUID — Foreign key → submissions.id — NOT NULL
  • step — SMALLINT — NOT NULL
  • content — TEXT — NOT NULL
  • requested_at — TIMESTAMP — NOT NULL

problems

  • id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT — NOT NULL
  • difficulty — SMALLINT — NOT NULL
  • concept_tags — JSONB — NOT NULL
  • starter_code — TEXT
  • time_limit_ms — INT — NOT NULL
  • memory_limit_kb — INT — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_by — UUID
  • created_at — TIMESTAMP — NOT NULL

refresh_tokens

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • family_id — UUID — NOT NULL
  • revoked — BOOLEAN — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL

streak_milestones

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • milestone_day — SMALLINT — NOT NULL
  • achieved_at — TIMESTAMP — NOT NULL
  • reward_granted — BOOLEAN — NOT NULL

submission_test_results

  • id — BIGSERIAL — Primary key — NOT NULL
  • submission_id — UUID — Foreign key → submissions.id — NOT NULL
  • test_case_id — BIGINT — Foreign key → test_cases.id — NOT NULL
  • passed — BOOLEAN — NOT NULL
  • actual_output — TEXT
  • execution_time_ms — INT
  • memory_kb — INT

submissions

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • problem_id — BIGINT — Foreign key → problems.id — NOT NULL
  • source_code — TEXT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • result — VARCHAR(20)
  • attempt_no — SMALLINT — NOT NULL
  • idempotency_key — VARCHAR(100) — NOT NULL
  • submitted_at — TIMESTAMP — NOT NULL
  • judged_at — TIMESTAMP

test_cases

  • id — BIGSERIAL — Primary key — NOT NULL
  • problem_id — BIGINT — Foreign key → problems.id — NOT NULL
  • input — TEXT — NOT NULL
  • expected_output — TEXT — NOT NULL
  • visibility — VARCHAR(10) — NOT NULL
  • display_order — SMALLINT — NOT NULL

user_gamification_states

  • user_id — UUID — Foreign key → users.id — NOT NULL
  • xp — BIGINT — NOT NULL
  • streak_days — INT — NOT NULL
  • max_streak_days — INT — NOT NULL
  • hearts_or_energy — SMALLINT — NOT NULL
  • last_active_date — DATE — NOT NULL
  • version — BIGINT — NOT NULL

user_interests

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • concept — VARCHAR(50) — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • learning_level — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • withdrawn_at — TIMESTAMP

weak_concept_records

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • concept — VARCHAR(50) — NOT NULL
  • weak_count — INT — NOT NULL
  • last_detected_at — TIMESTAMP — NOT NULL

xp_events

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • amount — INT — NOT NULL
  • reason — VARCHAR(30) — NOT NULL
  • submission_id — UUID — Foreign key → submissions.id
  • created_at — TIMESTAMP — NOT NULL