Vemo

Tables (12)

Captures

  • 캡쳐id (id) — INT — Primary key — NOT NULL
  • 시간 (timestamp) — TIME — NOT NULL
  • 이미지 (image) — VARCHAR(255) — NOT NULL
  • id (memos_id) — INT — Foreign key → Memos.id — NOT NULL

Channel

  • 채널id (id) — VARCHAR(24) — Primary key — NOT NULL
  • 썸네일 (thumbnails) — VARCHAR(255) — NOT NULL
  • 채널명 (title) — VARCHAR(100) — NOT NULL

Memo

  • 메모id (id) — INT — Primary key — NOT NULL
  • 시간 (timestamp) — TIME — NOT NULL
  • 메모 (description) — VARCHAR(1000) — NOT NULL
  • id (memos_id) — INT — Foreign key → Memos.id — NOT NULL

Memos

  • id — INT — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(50) — NOT NULL
  • 설명 (description) — VARCHAR(255) — NOT NULL
  • 생성시간 (created_at) — DATETIME — NOT NULL
  • id (user_id) — INT — Foreign key → Users.id — NOT NULL
  • id (video_id) — VARCHAR(11) — Foreign key → Videos.비디오id — NOT NULL

Playlists (Playlist)

  • 재생목록id (playlist_id) — INT — Primary key — NOT NULL
  • 재생목록명 (name) — VARCHAR(100) — NOT NULL
  • id (user_id) — INT — Foreign key → Users.id — NOT NULL

Playlists_Videos (Playlist_Video)

  • 재생목록id (playlist_id) — INT — Foreign key → Playlists.재생목록id — NOT NULL
  • 영상id (video_id) — VARCHAR(50) — Foreign key → Videos.비디오id — NOT NULL

Quiz

  • 퀴즈id (id) — INT — Primary key — NOT NULL
  • 시간 (timestamp) — TIME — NOT NULL
  • 문제 (question) — VARCHAR(100) — NOT NULL
  • 정답 (answer) — VARCHAR(100) — NOT NULL
  • id (quizzes_id) — INT — Foreign key → Quizzes.id — NOT NULL

Quizzes

  • id — INT — Primary key — NOT NULL
  • 비디오id (video_id) — VARCHAR(11) — Foreign key → Videos.비디오id — NOT NULL

Summaries

  • 요약본id (id) — INT — Primary key — NOT NULL
  • id (video_id) — VARCHAR(50) — Foreign key → Videos.비디오id — NOT NULL

Summary

  • 요약id (id) — INT — Primary key — NOT NULL
  • 시간 (timestamp) — TIME — NOT NULL
  • 내용 (content) — VARCHAR(255) — NOT NULL
  • 요약본id (summaries_id) — INT — Foreign key → Summaries.요약본id — NOT NULL

Users

  • id — INT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(30) — NOT NULL
  • 이메일 (email) — VARCHAR(100) — NOT NULL
  • 비밀번호 (password) — VARCHAR(60) — NOT NULL
  • 생년월일 (birth) — DATE — NOT NULL
  • 성별 (gender) — ENUM — NOT NULL
  • 닉네임 (nickname) — VARCHAR(30) — NOT NULL
  • 프로필사진 (profile_image) — VARCHAR(255)
  • 자기소개 (introduction) — VARCHAR(255)

Videos (Video)

  • 비디오id (id) — VARCHAR(11) — Primary key — NOT NULL
  • 제목 (title) — VARCHAR(100) — NOT NULL
  • 썸네일 (thumbnails) — VARCHAR(255) — NOT NULL
  • 영상시간 (duration) — TIME — NOT NULL
  • 분류 (category) — VARCHAR(50) — NOT NULL
  • 채널id (channel_id) — INT — Foreign key → Channel.채널id — NOT NULL