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)