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