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