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