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