lecture project
Tables (10)
CATEGORY (Untitled8)
- CATEGORY_NO (Key) — Primary key — NOT NULL
- NAME (Field)
- COURSE_NO (Key2) — Foreign key → Course.COURSE_NO — NOT NULL
CHAPTER (Untitled4)
- CHAPTER_NO (Key2) — Primary key — NOT NULL
- TITLE (Field2)
- DESCRIPTION (Field3)
- ORDER_NO (Field4)
- COURSE_NO (Key) — Foreign key → Course.COURSE_NO — NOT NULL
COURSE_TAG (Untitled11)
- COURSE_NO (Key2) — Foreign key → Course.COURSE_NO — NOT NULL
- TAG_NO (Key) — Foreign key → TAG.TAG_NO — NOT NULL
Course (Untitled2)
- COURSE_NO (Key) — Primary key — NOT NULL
- TITLE (Field)
- DESCRIPTION (Field2)
- PRICE (Field3)
- USER_NO (Key2) — Foreign key → User.USER_NO — NOT NULL
PROGRESS (Untitled6)
- PROGRESS_NO (Key) — Primary key — NOT NULL
- WATCHED_TIME (Field)
- COMPLETED (Field2)
- USER_NO (Key2) — Foreign key → User.USER_NO — NOT NULL
- VIDEO_NO (Key3) — Foreign key → Video.VIDEO_NO — NOT NULL
REVIEW (Untitled7)
- REVIEW_NO (Key3) — Primary key — NOT NULL
- COURSE_NO (Key) — Foreign key → Course.COURSE_NO — NOT NULL
- RATIING (Field)
- CONTENT (Field2)
- CREATE_AT (Field3)
TAG (Untitled9)
- TAG_NO (Key) — Primary key — NOT NULL
- NAME (Field)
THUMBNAIL (Untitled5)
- THUMBNAIL_NO (Key) — Primary key — NOT NULL
- THUMBNAIL_PATH (Field)
- ORIGIN_NAME (Field2)
- CONVERT_NAME (Field3)
- UPLOAD_TIME (Field4)
- DELETE_TIME (Field5)
User (Untitled)
- USER_NO (Key) — Primary key — NOT NULL
- USER_ID (Field)
- USER_NAME (Field3)
- PASSWORD (Field2)
- ROLE (Field4)
Video (Untitled3)
- VIDEO_NO (Key) — Primary key — NOT NULL
- CONVERT_NAME (Field)
- VIDEO_PATH (Field4)
- ORIGIN_NAME (Field5)
- CHAPTER_NO (Key2) — Foreign key → CHAPTER.CHAPTER_NO — NOT NULL
- THUMBNAIL_NO (Key3) — Foreign key → THUMBNAIL.THUMBNAIL_NO — NOT NULL