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