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 — 유저 아이디