MockCote

Tables (10)

Candidates (candidates)

  • query_id — int — Foreign key → Queries.query_id — NOT NULL
  • problem_id — int — Foreign key → Problems.problem_id — NOT NULL

Problems (problems)

  • problem_id — int — Primary key — NOT NULL
  • difficulty — int
  • title — varchar(50)

Queries (queries)

  • query_id — int — Primary key — NOT NULL
  • title — varchar(50)
  • query_str — varchar(100)
  • num_problems — int

session_participants

  • session_id — int — Foreign key → sessions.session_id — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL

session_problems

  • session_id — int — Foreign key → sessions.session_id — NOT NULL
  • problem_id — int — Foreign key → Problems.problem_id — NOT NULL

session_trackers

  • session_id — int — Foreign key → sessions.session_id — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL
  • problem_id — int — Foreign key → Problems.problem_id — NOT NULL
  • solved_at — timestamp
  • performance — int
  • language — varchar(30)
  • code_link — varchar(50)
  • dsecription — varchar(2000)

sessions

  • session_id — int — Primary key — NOT NULL
  • study_id — int — Foreign key → studies.study_id — NOT NULL
  • query_id — int — Foreign key → Queries.query_id — NOT NULL
  • start_at — timestamp
  • end_at — timestamp
  • problemPool (problem_pool) — varchar(100)

studies

  • study_id — int — Primary key — NOT NULL
  • owner_id — int — Foreign key → users.user_id — NOT NULL
  • name — varchar(50)
  • description — varchar(2000)
  • code — varchar(50)

study_members

  • study_id — int — Foreign key → studies.study_id — NOT NULL
  • user_id — int — Foreign key → users.user_id — NOT NULL

users

  • user_id — int — Primary key — NOT NULL
  • handle — varchar(50)
  • password — varchar(50)
  • level — int