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