ERD-LearnHub

Tables (10)

announcement (공지사항)

  • id — int — Primary key — NOT NULL
  • teacher_id — int — Foreign key → teacher.id — NOT NULL
  • 제목 (title) — varchar(50) — NOT NULL
  • 내용 (content) — varchar(500) — NOT NULL
  • 공개여부 (visibility) — tinyint(1) — NOT NULL — 0: 비공개
  • 생성일자 (created_at) — int — NOT NULL
  • 수정일자 (updated_at) — int — NOT NULL

class (수업)

  • id — int — Primary key — NOT NULL
  • teacher_id — int — Foreign key → teacher.id — NOT NULL
  • 과목명 (title) — varchar(50) — NOT NULL
  • 수업요일 (class_day) — ENUM — NOT NULL — Monday/Tuesday/Wednesday/Thursday/Friday/Saturday/Sunday
  • 수업시작일 (start_time) — timestamp — NOT NULL
  • 수업종료일 (end_time) — timestamp — NOT NULL
  • 교시 (period) — int — NOT NULL
  • 생성일자 (created_at) — timestamp — NOT NULL
  • 수정일자 (updated_at) — timestamp — NOT NULL

class_enrollment (수업등록정보)

  • class_id — int — Foreign key → class.id — NOT NULL
  • student_id — int — Foreign key → student.id — NOT NULL
  • teacher_id — int — Foreign key → class.teacher_id — NOT NULL

quiz (퀴즈)

  • id — int — Primary key — NOT NULL
  • teacher_id — int — Foreign key → teacher.id — NOT NULL
  • 제목 (title) — varchar(50) — NOT NULL
  • 생성일자 (created_at) — timestamp — NOT NULL
  • 수정일자 (updated_at) — timestamp — NOT NULL

quiz_multiple_choice (퀴즈-선다형)

  • id — int — Primary key — NOT NULL
  • quiz_id — int — Foreign key → quiz.id — NOT NULL
  • teacher_id — int — Foreign key → quiz.teacher_id — NOT NULL
  • 퀴즈내용 (content) — varchar(500) — NOT NULL
  • 정답 (correct_option) — int — NOT NULL
  • 옵션1 (option_1) — varchar(500) — NOT NULL
  • 옵션2 (option_2) — varchar(500) — NOT NULL
  • 옵션3 (option_3) — varchar(500) — NOT NULL
  • 옵션4 (option_4) — varchar(500) — NOT NULL
  • 제한시간 (deadline) — int — NOT NULL — 초단위
  • 문제해설 (explanation) — varchar(500) — NOT NULL

quiz_result (퀴즈답변)

  • Key — Primary key — NOT NULL
  • id — int — Foreign key → quiz_multiple_choice.id — NOT NULL
  • quiz_id — int — Foreign key → quiz_multiple_choice.quiz_id — NOT NULL
  • teacher_id — int — Foreign key → quiz_multiple_choice.teacher_id — NOT NULL
  • id (id2) — int — Foreign key → quiz_true_false.id — NOT NULL
  • quiz_id (quiz_id2) — int — Foreign key → quiz_true_false.quiz_id — NOT NULL
  • teacher_id (teacher_id2) — int — Foreign key → quiz_true_false.teacher_id — NOT NULL
  • id (id3) — int — Foreign key → quiz_short_answer.id — NOT NULL
  • quiz_id (quiz_id3) — int — Foreign key → quiz_short_answer.quiz_id — NOT NULL
  • teacher_id (teacher_id3) — int — Foreign key → quiz_short_answer.teacher_id — NOT NULL

quiz_short_answer (퀴즈-단답형)

  • id — int — Primary key — NOT NULL
  • quiz_id — int — Foreign key → quiz.id — NOT NULL
  • teacher_id — int — Foreign key → quiz.teacher_id — NOT NULL
  • 퀴즈내용 (content) — varchar(500) — NOT NULL
  • 제한시간 (deadline) — int — NOT NULL
  • 정답 (coreect_answer) — varchar(500) — NOT NULL
  • 문제해설 (explanation) — varchar(500) — NOT NULL

quiz_true_false (퀴즈-OX)

  • id — int — Primary key — NOT NULL
  • quiz_id — int — Foreign key → quiz.id — NOT NULL
  • teacher_id — int — Foreign key → quiz.teacher_id — NOT NULL
  • 퀴즈내용 (content) — varchar(500) — NOT NULL
  • 제한시간 (deadline) — int — NOT NULL — 초단위
  • 정답 (coreect_answer) — varchar(500) — NOT NULL
  • 문제해설 (explanation) — varchar(500) — NOT NULL

student (학생)

  • id — int — Primary key — NOT NULL
  • 학번 (student_number) — varchar(50) — NOT NULL
  • 이름 (name) — varchar(50) — NOT NULL
  • 생성일자 (created_at) — timestamp — NOT NULL
  • 수정일자 (updated_at) — timestamp — NOT NULL

teacher (선생님)

  • id — int — Primary key — NOT NULL
  • 이메일 (email) — varchar(50) — NOT NULL
  • 비밀번호 (password) — varchar(200) — NOT NULL
  • 이름 (name) — varchar(50) — NOT NULL
  • 전화번호 (phone_number) — varchar(50) — NOT NULL
  • 계정상태 (status) — ENUM — NOT NULL — available/suspended/on_leave
  • 생성일자 (created_at) — timestamp — NOT NULL
  • 수정일자 (updated_at) — timestamp — NOT NULL