테스트
테이블 (16)
analytics_overview
- id — UUID
- user_id — UUID — NOT NULL
- solved — INT
- incorrect — INT
- retried — INT
- accuracy — FLOAT
- streak_days — INT
auth_tokens
- access_token — TEXT
- user_id — UUID — NOT NULL
badges
- id — UUID
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100)
- description — TEXT
- icon_url — TEXT
friends
- id — UUID
- user_id — UUID — NOT NULL
- friend_id — UUID — NOT NULL
- status — VARCHAR(20)
- created_at — TIMESTAMP
hints
- id — UUID
- problem_id — UUID — NOT NULL
- stage — VARCHAR(20)
- content — TEXT
- order_num — INT
- created_by — VARCHAR(20)
- created_at — TIMESTAMP
language_usage
- user_id — UUID — NOT NULL
- language — VARCHAR(50)
- ratio — FLOAT
level_distribution
- user_id — UUID — NOT NULL
- level — INT
- solved — INT
problem_algorithm_tags
- problem_id — UUID — NOT NULL
- algorithm_name — VARCHAR(100) — NOT NULL
problem_recommendations
- id — UUID
- problem_id — UUID — NOT NULL
- reason — TEXT
- rank_score — FLOAT
problem_solved
- id — UUID
- problem_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- verdict — VARCHAR(10)
- date — DATE
problem_types
- problem_id — UUID — NOT NULL
- type_name — VARCHAR(100) — NOT NULL
problems
- id — UUID
- slug — VARCHAR(100) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- difficulty — INT
- accuracy — FLOAT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
runs
- run_id — UUID
- problem_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- language — VARCHAR(50)
- status — VARCHAR(20)
- stdout_url — TEXT
- stderr_url — TEXT
- created_at — TIMESTAMP
submissions
- id — UUID
- problem_id — UUID — NOT NULL
- user_id — UUID — NOT NULL
- language — VARCHAR(50)
- status — VARCHAR(20)
- verdict — VARCHAR(5)
- runtime_ms — INT
- memory_kb — INT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
user_badges
- user_id — UUID — 기본 키 — NOT NULL
- badge_id — UUID — 기본 키 — NOT NULL
users
- id — UUID
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- level — INT
- xp — INT
- display_name — VARCHAR(100)
- avatar_url — TEXT
- timezone — VARCHAR(50)
- bio — TEXT