database

Tables (11)

Cart (장바구니)

  • CartID (장바구니ID) — int — Primary key
  • UserID (아이디) — varchar(50) — Foreign key → Users.UserID
  • UserID (유저ID) — int — FK
  • LectureiD (강의ID) — int — FK
  • Date (등록날짜) — datetime

Category (카테고리)

  • CategoryID (카테코리ID) — int — Primary key
  • LectureID (강의ID) — int — Foreign key → Lecture.LectureID
  • UserID (아이디) — varchar(50) — Foreign key → Lecture.UserID
  • InstructorID (강사ID2) — int — Foreign key → Lecture.InstructorID
  • TOCID (목차ID) — int — Foreign key → Lecture.TOCID
  • CategoryName (카테코리이름) — varchar(255)

Comment (댓글)

  • CommentID (댓글ID) — int — Primary key
  • LectureID (강의ID) — int — FK
  • UserID (유저ID) — int — FK
  • Comment (댓글) — text
  • Score (평점) — float — 0.0/5.0

Enrollment (수강)

  • EnrollmentID (수강ID) — int — Primary key
  • UserID (아이디) — varchar(50) — Foreign key → Users.UserID
  • UserID (유저ID) — int — FK
  • LectureID (강의ID) — int — FK
  • EnrollmentDate (등록날짜) — date
  • AttendanceRate (출석비율) — float
  • payment (결제여부) — int — Y/N

Instructor (강사)

  • InstructorID (강사ID) — int — Primary key
  • InstructorName (강사이름) — varchar(255)
  • Email (이메일) — varchar(255)
  • Qualifications (경력) — text
  • InstructorImage (강사이미지) — varchar(1024)

Lecture (강의)

  • LectureID (강의ID) — int — Primary key
  • InstructorID (강사ID2) — int — Foreign key → Instructor.InstructorID
  • UserID (아이디) — varchar(50) — Foreign key → Users.UserID
  • TOCID (목차ID) — int — Foreign key → LectureTOC.TOCID
  • Title (제목) — varchar(255)
  • LectureImageUrl (강의이미지) — varchar(1024)
  • Description (강의설명) — text
  • instructorID (강사ID) — int — FK
  • price (가격) — int
  • Startdate (날짜) — datetime

LectureCategory (코스카테고리)

  • LectureID (강의ID) — int — Primary key — FK
  • CategoryID (카테고리ID) — int — Primary key — FK

LectureMeterial (강의자료)

  • MeterialID (자료ID) — int — Primary key
  • LectureID (강의ID) — int — Foreign key → Lecture.LectureID
  • InstructorID (강사ID2) — int — Foreign key → Lecture.InstructorID
  • UserID (아이디) — varchar(50) — Foreign key → Lecture.UserID
  • TOCID (목차ID2) — int — Foreign key → Lecture.TOCID
  • TOCID (목차ID) — int — FK
  • MeterialType (자료타입) — varchar(255) — Video,PDF,Slide
  • MeterialURL (자료URL) — varchar(255)
  • Description (설명) — text

LectureTOC (강의목차)

  • TOCID (목차ID) — int — Primary key
  • LectureID (강의ID) — int — FK
  • ParentTOCID (부모목차ID) — int — FK
  • Title (제목) — varchar(255)
  • videoLength (강의길이) — int
  • Description (강의설명) — text

Payments (결제)

  • PaymentID (결제ID) — int — Primary key
  • UserID (유저ID) — int — FK
  • Amount (가격) — int
  • PaymentDate (결제날짜) — date
  • LectureID (강의ID) — int — FK

Users (유저)

  • UserID (아이디) — varchar(50) — Primary key
  • Username (닉네임) — varchar(50)
  • Passward (비밀번호) — varchar(50)
  • UserType (유저타입) — varchar(50)
  • UserImage (프로필사진) — varchar(1024)