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)