pairprogramming

Tables (6)

MEMBER (회원)

  • MEMBER_ID (회원ID) — NUMBER — Primary key — NOT NULL
  • EMAIL (이메일) — VARCHAR(255)
  • PASSWORD (비밀번호) — VARCHAR(255)
  • NAME (이름) — VARCHAR(255)
  • UUID (고유번호) — VARCHAR(255)

PROBLEM (문제)

  • PROBLEM_ID (문제ID) — NUMBER — Primary key — NOT NULL
  • TITLE (제목) — VARCHAR(255)
  • DESCRIPTION (설명) — VARCHAR(255)
  • RESTRICTION (제한사항) — VARCHAR(255)
  • INPUT_OUTPUT_EXAMPLE (입출력예시) — VARCHAR(255)
  • RANK (난이도) — VARCHAR(255)

PROBLEM_ANSWER (문제 답변)

  • PROBLEM_ANSWER_ID (문제 답변ID) — NUMBER — Primary key — NOT NULL
  • PROBLEM_ID (문제ID) — NUMBER — Foreign key → PROBLEM.PROBLEM_ID — NOT NULL
  • MEMBER_ID (회원ID) — NUMBER — Foreign key → MEMBER.MEMBER_ID — NOT NULL
  • CODE (코드) — VARCHAR(255)
  • LANGUAGE (언어) — VARCHAR(255)
  • UUID (고유번호) — VARCHAR(255)

PROBLEM_ANSWER_SUBMIT (문제 답변 제출내역)

  • PROBLEM_ANSWER_SUBMIT_ID (문제 답변 제출내역ID) — NUMBER — Primary key — NOT NULL
  • PROBLEM_ANSWER_ID (문제 답변ID) — NUMBER — Foreign key → PROBLEM_ANSWER.PROBLEM_ANSWER_ID — NOT NULL
  • CODE (코드) — VARCHAR(255)
  • LANGUAGE (언어) — VARCHAR(255)
  • STATUS (성공여부) — VARCHAR(255)
  • SUBMIT_DATE (제출일시) — TIMESTAMP
  • UUID (고유번호) — VARCHAR(255)

PROBLEM_FORMAT (문제 포멧)

  • PROBLEM_FORMAT_ID (문제 포멧ID) — NUMBER — Primary key — NOT NULL
  • PROBLEM_ID (문제ID) — NUMBER — Foreign key → PROBLEM.PROBLEM_ID — NOT NULL
  • CODE (코드) — VARCHAR(255)
  • LANGUAGE (언어) — VARCHAR(255)

PROBLEM_TEST_CASE (문제 테스트 케이스)

  • PROBLEM_TEST_CASE_ID (문제 테스트 케이스ID) — NUMBER — Primary key — NOT NULL
  • PROBLEM_ID (문제ID) — NUMBER — Foreign key → PROBLEM.PROBLEM_ID — NOT NULL
  • INPUT (입력) — VARCHAR(255)
  • OUTPUT (출력) — VARCHAR(255)