woorksheet

Tables (5)

assignedWorksheet (ASSIGNED_WORKSHEET)

  • id (ID) — BIGINT — Primary key — NOT NULL — 부여된 학습지 ID
  • studentId (STUDENT_ID) — BIGINT — Foreign key → student.id — NOT NULL — 학생 ID
  • worksheetId (WORKSHEET_ID) — BIGINT — Foreign key → worksheet.id — NOT NULL — 학습지 ID
  • submittedAnswers (SUBMITTED_ANSWERS) — TEXT — NOT NULL — 제출한 답(Json 형태로 저장)
  • correctCount (CORRECT_CNT) — INT
  • problemEvaluations (PROBLEM_EVALUATIONS) — VARCHAR(128) — NOT NULL — 문제 채점 결과 (0,1,0,1) 맞았으면 1 틀렸으면 0

problem (PROBLEM)

  • id (ID) — BIGINT — Primary key — NOT NULL — 문제 ID
  • unitCode (UNIT_CODE) — INT — NOT NULL — 문제 유형코드
  • problemType (PROBLEM_TYPE) — VARCHAR(20) — NOT NULL — 문제 종류(SUBJECTIVE, SELECTION)
  • difficulty (DIFFICULTY) — TINYINT — NOT NULL — 문제 난이도(1 ~ 5)
  • answer (ANSWER) — VARCHAR(255) — NOT NULL — 정답

student (STUDENT)

  • id (ID) — BIGINT — Primary key — NOT NULL — 학생 ID
  • name (NAME) — VARCHAR(20) — NOT NULL — 유저 이름

teacher (TEACHER)

  • id (ID) — BIGINT — Primary key — NOT NULL — 선생님 ID
  • name (NAME) — VARCHAR(20) — NOT NULL — 선생님 이름

worksheet (WORKSHEET)

  • id (ID) — BIGINT — Primary key — NOT NULL — 학습지 ID
  • teacherId (TEACHER_ID) — BIGINT — Foreign key → teacher.id — NOT NULL — 선생님 ID
  • name (NAME) — VARCHAR(20) — NOT NULL — 학습지 이름
  • problemIds (PROBLEM_IDS) — VARCHAR(1024) — NOT NULL — 문제 ID 리스트 PROBLEM Table의 ID를 참조