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