online-judge
Tables (6)
problem (Untitled2)
- problem_id — int — Primary key — NOT NULL
- title (Field)
- problem_info (Field2)
- input_info (Field3)
- output_info (Field4)
problem-judge (Untitled5)
- judge_id (Key) — Primary key — NOT NULL
- problem_id — int — Foreign key → problem.problem_id — NOT NULL
- input_judge (Field)
- output_judge (Field2)
problem_example (Untitled3)
- example_id (Key2) — Primary key — NOT NULL
- problem_id — int — Foreign key → problem.problem_id — NOT NULL
- input_example (Field)
- output_example (Field2)
submit (Untitled4)
- submit_id (Key) — Primary key — NOT NULL
- user_id (id) — varchar — Foreign key → user.user_id — NOT NULL
- problem_id — int — Foreign key → problem.problem_id — NOT NULL
- code
- solved (Field)
submit-result (Untitled6)
- submit_id (Key2) — Foreign key → submit.submit_id — NOT NULL
- user_id (id2) — varchar — Foreign key → submit.user_id — NOT NULL
- problem_id (problem_id2) — int — Foreign key → submit.problem_id — NOT NULL
- judge_id (Key) — Foreign key → problem-judge.judge_id — NOT NULL
- problem_id — int — Foreign key → problem-judge.problem_id — NOT NULL
- result (Field)
user (Untitled)
- user_id — varchar — Primary key — NOT NULL
- password — varchar