dquiz
Tables (9)
Class (강의)
- class_id (Key) — LONG — Primary key — NOT NULL
- class_name (Field) — VARCHAR
- class_code (Field2) — VARCHAR
ClassAdmins (강의-관리자 조인테이블)
- classadmins_id (Key) — LONG — Primary key — NOT NULL
- user_id (강의운영자) — INTEGER — Foreign key → User.user_id — NOT NULL
- class_id (강의이름) — LONG — Foreign key → Class.class_id — NOT NULL
ClassQuizSet (강의 퀴즈셋)
- class_quiz_set_id (Key3) — LONG — Primary key — NOT NULL
- class_id (Key) — LONG — Foreign key → Class.class_id — NOT NULL
- quizset_id (Key2) — LONG — Foreign key → QuizSet.quizset_id — NOT NULL
ClassUser (강의-유저 조인테이블)
- class_user_id (Key) — LONG — Primary key — NOT NULL
- class_id (Key2) — LONG — Foreign key → Class.class_id — NOT NULL
- user_id (Key3) — INTEGER — Foreign key → User.user_id — NOT NULL
Quiz (퀴즈)
- quiz_id (Key) — LONG — Primary key — NOT NULL
- quizset_id (Key2) — LONG — Foreign key → QuizSet.quizset_id — NOT NULL
- quiz_title (퀴즈 이름) — INTEGER
- quiz_type (객관식,주관식) — INTEGER
- quiz_content (퀴즈 내용(JSON)) — VARCHAR
- quiz_answer (퀴즈 정답) — VARCHAR
QuizResult (퀴즈결과)
- user_id (Key3) — LONG — Foreign key → User.user_id — NOT NULL
- quiz_id (Key) — LONG — Foreign key → Quiz.quiz_id — NOT NULL
- quizsetresult_id (Key2) — LONG — Foreign key → QuizSetResult.quizsetresult_id — NOT NULL
- score (Field) — INTEGER
QuizSet (퀴즈셋)
- quizset_id (Key) — LONG — Primary key — NOT NULL
- user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
- quizset_name (퀴즈셋 이름) — VARCHAR
- total_score (퀴즈모음 총점) — INTEGER
QuizSetResult (퀴즈모음결과)
- quizsetresult_id (Key) — LONG — Primary key — NOT NULL
- class_quiz_set_id (Key32) — LONG — Foreign key → ClassQuizSet.class_quiz_set_id — NOT NULL
- user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
- total_score (Field) — INTEGER
User (유저)
- user_id (Key) — LONG — Primary key — NOT NULL
- nickname (Field) — INTEGER
- username (Field2) — INTEGER
- password (Field3) — INTEGER
- authority (학생,교수자) — ENUM
- admin (Field4) — ENUM