sroom0626

Tables (13)

CHAPTER

  • id — int
  • video_id — varchar(225) — NOT NULL
  • start_time — int — NOT NULL
  • duration — int — NOT NULL
  • summary_id — bigint

COURSE

  • Key — Primary key — NOT NULL
  • id — bigint
  • member_id — bigint — NOT NULL
  • title — varchar(255) — NOT NULL
  • duration — int — NOT NULL
  • last_view_time — timestamp
  • progress — float — NOT NULL
  • thumbnail — varchar(255)
  • is_scheduled — tinyint(1) — NOT NULL
  • weeks — int
  • expected_end_date — timestamp
  • daily_target_time — int

COURSEQUIZ

  • id — bigint
  • course_id — bigint — NOT NULL
  • quiz_id — bigint — NOT NULL
  • submitted_answer — int
  • is_correct — tinyint(1) — NOT NULL
  • is_scrapped — tinyint(1) — NOT NULL
  • submitted_time — timestamp — NOT NULL

COURSEVIDEO

  • id — bigint
  • course_id — bigint — NOT NULL
  • video_id — bigint
  • section — int
  • video_index — int — NOT NULL
  • view_duration — int — NOT NULL
  • is_complete — tinyint — NOT NULL
  • summary_id — bigint — NOT NULL

COURSE_DAILY_LOG

  • id — bigint
  • course_id — bigint — NOT NULL
  • lecture_id (Field) — NOT NULL
  • date — timestamp
  • learning_time — int — NOT NULL
  • quiz_count — int — NOT NULL
  • lecture_count — int — NOT NULL

LECTURE

  • id — bigint
  • course_id — bigint — NOT NULL
  • source_id — varchar(225) — NOT NULL
  • is_playlist — tinyint — NOT NULL
  • lecture_index — int — NOT NULL
  • is_reviewed — tinyint(1) — NOT NULL

MEMBER

  • Key (id) — bigint — Primary key — NOT NULL
  • member_id — varchar(225)
  • name — varchar(255) — NOT NULL
  • refresh_token — varchar(255)
  • correctness_rate — float — NOT NULL
  • completion_rate — float — NOT NULL
  • total_learning_time — int — NOT NULL
  • sign_up_time — timestamp — NOT NULL
  • status — tinyint — NOT NULL
  • bio — varchar(255)

PLAYLIST

  • id — bigint
  • playlist_id — varchar(225) — NOT NULL
  • channel — varchar(255) — NOT NULL
  • thumbnail — varchar(255)
  • accumulated_rating — int — NOT NULL
  • review_count — int — NOT NULL
  • is_available — tinyint(1)
  • description — text

QUIZ

  • id — bigint
  • lecture_id — bigint — NOT NULL
  • type — int — NOT NULL — 1: 객관식, 2: 주관식, 3: TF
  • question — text — NOT NULL
  • answer — text — NOT NULL

QUIZ_OPTION

  • id — bigint
  • quiz_id — bigint — NOT NULL
  • option_text — text — NOT NULL

REVIEW

  • id — bigint
  • member_id — bigint — NOT NULL
  • lecture_id — bigint — NOT NULL
  • submitted_rating — int — NOT NULL
  • content — varchar(225)
  • submitted_date — timestamp

SUMMARY

  • id — bigint
  • content — text — NOT NULL
  • updated_time — timestamp

VIDEO

  • id — bigint
  • video_id — varchar(225) — NOT NULL
  • playlist_id — bigint
  • duration — int — NOT NULL
  • channel — varchar(255) — NOT NULL
  • thumbnail — varchar(255) — NOT NULL
  • view_count — bigint — NOT NULL
  • accumulated_rating — int — NOT NULL
  • review_count — int — NOT NULL
  • summary_id — varchar(255) — NOT NULL
  • is_available — tinyint — NOT NULL
  • description — text
  • is_divided — tinyint — NOT NULL
  • title — varchar(225) — NOT NULL
  • language — varchar(50)
  • license — tinyint — NOT NULL — 0: Standard YouTube License, 1: creative commons