toyproject
Tables (11)
CrawledQuery
- query_id — BIGINT
- user_id — BIGINT — NOT NULL
- query_string — TEXT — NOT NULL
- source — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
CrawledSolution
- solution_id — BIGINT
- problem_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- solution_code — TEXT — NOT NULL
- is_public — BOOLEAN
LiveCodingParticipant
- participant_id — BIGINT
- session_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- is_present — BOOLEAN
- problem_id — BIGINT
- solved_at — DATETIME
- execution_time — INT
LiveCodingSession
- session_id — BIGINT
- study_id — BIGINT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME
Presentation
- presentation_id — BIGINT
- session_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- problem_id — BIGINT — NOT NULL
Problem
- problem_id — BIGINT
- source — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- url — VARCHAR(255) — NOT NULL
- tags — TEXT
- difficulty — VARCHAR(50)
- created_at — DATETIME
- updated_at — DATETIME
ProblemRecommendation
- recommendation_id — BIGINT
- problem_id — BIGINT — NOT NULL
- study_id — BIGINT — NOT NULL
- created_at — DATETIME
SolutionSummary
- summary_id — BIGINT
- problem_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- summary_text — TEXT — NOT NULL
- created_at — DATETIME
Study
- study_id — BIGINT
- study_name — VARCHAR(255) — NOT NULL
- host_user_id — BIGINT — NOT NULL
- invite_link — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
StudyMember
- study_member_id — BIGINT
- study_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- joined_at — DATETIME
User
- user_id — BIGINT
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- handle — VARCHAR(255)
- is_study_host — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME