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