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