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