kji erd

Tables (9)

Answer

  • seq — Long — Primary key — NOT NULL
  • 답변 (Field) — text
  • createdDtime
  • modifiedDtime
  • status
  • questionSeq — Long — Foreign key → Question.seq — NOT NULL
  • examUserSeq (seq2) — Long — Foreign key → ExamUser.seq — NOT NULL

Course

  • seq — Long — Primary key — NOT NULL

CourseModule

  • seq — Primary key — NOT NULL
  • type — enum(EXAM,HOMEWORK,REVIEW) — 구분
  • limitScore — Long
  • limitRatio — Long
  • limitRatioType — enum(PERCENT,CHASI)
  • courseExamSeq — Long
  • courseHomeworkSeq — Long
  • createdDtime
  • modifiedDtime
  • status
  • courseSeq — Long — Foreign key → Course.seq — NOT NULL
  • targetSeq — Long — Foreign key → Exam.seq — NOT NULL

CourseUser

  • seq — Primary key — NOT NULL
  • courseClassSeq — Long
  • userSeq — Long — Foreign key → User.seq — NOT NULL

Exam

  • seq — Long — Primary key — NOT NULL
  • type — enum(MID_EXAM,FINAL_EXAM)
  • name — String
  • 재시험가능여부 (Field) — Bool
  • 총점 (Field2) — int
  • 시험시간 (Field3)
  • createdDtime
  • modifiedDtime
  • status

ExamUser (Untitled2)

  • seq — Long — Primary key — NOT NULL
  • startTime — Date
  • endTime — Date
  • 점수 (Field) — int
  • createdDtime — Date
  • modifiedDtime
  • status
  • examSeq — Foreign key → Exam.seq — NOT NULL
  • courseUserSeq — Long — Foreign key → CourseUser.seq — NOT NULL

Question

  • seq — Primary key — NOT NULL
  • 시험 질문 (Field) — text
  • 배점 (Field2) — Number
  • 정답 (Field3) — List
  • 설명 (Field4) — text
  • type (enum(5지선다, 서술형, 등등등))
  • defaultType
  • sort
  • createdDtime
  • modifiedDtime
  • status
  • examSeq — Long — Foreign key → Exam.seq — NOT NULL

QuestionChoice

  • seq — Primary key — NOT NULL
  • 순서 (Field) — int
  • 선택지 (Field2) — text
  • createdDtime
  • modifiedDtime
  • status
  • questionSeq — Foreign key → Question.seq — NOT NULL

User

  • seq — Long — Primary key — NOT NULL
  • username — String — 유저 아이디