LMS

테이블 (13)

Q&A 게시판 (qna_board)

  • ask_number — NUMBER — 기본 키
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • class_number — NUMBER — 외래 키 → 강의.class_number
  • ask_title — VARCHAR2(100) — NOT NULL
  • ask_content — CLOB — NOT NULL
  • ask_create_time — TIMESTAMP
  • ask_update_time — TIMESTAMP

Q&A 답변 (qna_comment)

  • comment_number — NUMBER — 기본 키 — NOT NULL
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • ask_number — NUMBER — 외래 키 → Q&A 게시판.ask_number
  • comment_content — VARCHAR2
  • comment_create_time — TIMESTAMP

강의 (class)

  • class_number — NUMBER — 기본 키
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • class_title — VARCHAR2(100) — NOT NULL
  • class_description — CLOB
  • class_category — VARCHAR2(50)
  • class_create_time — TIMESTAMP
  • class_update_time — TIMESTAMP
  • thumbnail_path — CLOB

강의영상 (video)

  • video_number — NUMBER — 기본 키
  • chapter_number — NUMBER — 외래 키 → 챕터.chapter_number — NOT NULL
  • video_title — VARCHAR2(100) — NOT NULL
  • video_id — VARCHAR2(30) — NOT NULL
  • video_duration — NUMBER
  • video_create_time — TIMESTAMP
  • video_order_number — NUMBER — NOT NULL

강의영상 수강상태 (video_progress)

  • video_progress_number — NUMBER — 기본 키 — NOT NULL
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • video_number — NUMBER — 외래 키 → 강의영상.video_number
  • video_duration — NUMBER(10,2)
  • last_watched_time — NUMBER(10,2)
  • watched_percentage — NUMBER(5,2)
  • video_progress_update_time — TIMESTAMP
  • completed — NUMBER(1)

공지 (notice)

  • notice_number — NUMBER — 기본 키 — NOT NULL
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • class_number — NUMBER — 외래 키 → 강의.class_number
  • notice_content — CLOB
  • notice_create_time — TIMESTAMP
  • notice_title — VARCHAR2(255)

문제 (question)

  • question_number — NUMBER — 기본 키
  • chapter_number — NUMBER — 외래 키 → 퀴즈.chapter_number — NOT NULL
  • quiz_number (quiz_number2) — NUMBER — 외래 키 → 퀴즈.quiz_number
  • question_type — VARCHAR2(50)
  • question_text — CLOB — NOT NULL
  • right_answer — NUMBER(1,0)
  • question_score — NUMBER — NOT NULL

사용자 (users)

  • users_number — NUMBER — 기본 키 — NOT NULL
  • id — VARCHAR2(50) — NOT NULL
  • nickname — VARCHAR2(50)
  • password — VARCHAR2(128) — NOT NULL
  • name — VARCHAR2(50) — NOT NULL
  • email — VARCHAR2(128) — NOT NULL
  • phone_number — VARCHAR2(15)
  • profile_path — CLOB
  • grade — NUMBER(1,0)

사용자 수강상태 (users_progress)

  • users_progress_number — NUMBER — 기본 키 — NOT NULL
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • completion_status — NUMBER(1)
  • completion_rate — NUMBER(5,2)
  • progress_update_time — TIMESTAMP

수강평 (rate)

  • rate_number — NUMBER — 기본 키 — NOT NULL
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • class_number — NUMBER — 외래 키 → 강의.class_number
  • rate_score — NUMBER
  • rate_content — CLOB

챕터 (chapter)

  • chapter_number — NUMBER — 기본 키 — NOT NULL
  • class_number — NUMBER — 외래 키 → 강의.class_number
  • chapter_name — VARCHAR2(100)
  • chapter_create_time — TIMESTAMP

퀴즈 (quiz)

  • quiz_number — NUMBER — 기본 키
  • chapter_number — NUMBER — 외래 키 → 챕터.chapter_number — NOT NULL
  • quiz_title — VARCHAR2(100) — NOT NULL
  • quiz_duration — NUMBER
  • create_time — TIMESTAMP

학생답안 (answer)

  • ANSWER_NUMBER — NUMBER — 기본 키
  • users_number — NUMBER — 외래 키 → 사용자.users_number — NOT NULL
  • question_number — NUMBER — 외래 키 → 문제.question_number
  • answer_text — CLOB
  • SCORE — NUMBER