LMS
Tables (9)
Cart (Untitled6)
- cart_id (id) — int — Primary key — NOT NULL — Auto Increament
- User_id (id2) — int — Foreign key → Student.User_id — NOT NULL — Auto Increment
CartItem (Untitled7)
- cartItem_id (id) — int — Primary key — NOT NULL — Auto Increament
- lecture_id (id2) — int — Foreign key → Lecture.lecture_id — NOT NULL — Auto Increament
- cart_id (id3) — int — Foreign key → Cart.cart_id — NOT NULL — Auto Increament
- User_id (id22) — int — Foreign key → Cart.User_id — NOT NULL — Auto Increment
- category_id (id23) — int — Foreign key → Lecture.category_id — NOT NULL — Auto Increament
Category (Untitled8)
- category_id (id) — int — Primary key — NOT NULL — Auto Increament
- 이름 (name) — varcher(255) — NOT NULL
- 설명 (description) — vercher(255) — NOT NULL
Lecture (Untitled3)
- lecture_id (id) — int — Primary key — NOT NULL — Auto Increament
- category_id (id2) — int — Foreign key → Category.category_id — NOT NULL — Auto Increament
- 이름 (name) — varcher(255) — NOT NULL
- 과목 (subject) — varcher(100) — NOT NULL
Student (Untitled)
- User_id (id) — int — Primary key — NOT NULL — Auto Increment
- 이름 (name) — Varcher(100) — NOT NULL — 유저의 이름 생성.
- 이메일 (email) — varcher(255) — NOT NULL — 이메일 계정. 로그인 할 경우 필요로함.
- 비밀번호 (password) — varcher(255) — NOT NULL — 로그인 시 사용되는 비밀번호
- 나이 (age) — varcher(5) — NOT NULL
- 역할 (role) — varcher(50) — NOT NULL — 학생의 역할 설정
- 학년 (grade) — varcher(50) — NOT NULL
- 학교 (school) — varcher(100) — NOT NULL
- 성별 (gender) — varcher(50) — NOT NULL
Student_Lecture (Untitled4)
- User_id (id) — int — Foreign key → Student.User_id — NOT NULL — Auto Increment
- lecture_id (id2) — int — Foreign key → Lecture.lecture_id — NOT NULL — Auto Increament
- category_id (id22) — int — Foreign key → Lecture.category_id — NOT NULL — Auto Increament
- 진행율 (progress) — int — NOT NULL
Teacher
- teacher_id (id) — int — Primary key — NOT NULL — Auto Increament
- 이름 (name) — varcher(100) — NOT NULL — 강사의 이름
- 이메일 (email) — varcher(255) — NOT NULL
- 비밀번호 (password) — varcher(255) — NOT NULL
- 성별 (gender) — varcher(255) — NOT NULL
- 역할 (role) — varcher(50) — NOT NULL
Teacher_Lecture (Untitled5)
- teacher_id (id) — int — Foreign key → Teacher.teacher_id — NOT NULL — Auto Increament
- lecture_id (id2) — int — Foreign key → Lecture.lecture_id — NOT NULL — Auto Increament
- category_id (id22) — int — Foreign key → Lecture.category_id — NOT NULL — Auto Increament
Teacher_Student (Untitled2)
- teacher_id (id) — int — Foreign key → Teacher.teacher_id — NOT NULL — Auto Increament
- User_id (id2) — int — Foreign key → Student.User_id — NOT NULL — Auto Increment