Youtube Crawler
Tables (3)
channel_info (Untitled)
- 채널 id (channel_id) — TEXT — Primary key — NOT NULL
- 채널이름 (channel_name) — TEXT
- 구독자수 (subscribe_count) — INT
- 채널설명 (channel_description) — TEXT
channel_upload (Untitled3)
- 영상 id (video_id) — TEXT — Primary key
- 채널 id (channel_id) — TEXT — Foreign key → channel_info.채널 id — NOT NULL
- 업로드시간 (pub_time) — TEXT
- 영상설명 (description) — TEXT
- 썸네일URL (thumbnail_URL) — TEXT
- 동영상URL (video_URL) — TEXT
monthly_upload_videos (Untitled2)
- 영상 id (Field) — TEXT — Foreign key → channel_upload.영상 id
- 영상뷰수 (views) — INT
- 영상좋아요수 (likes) — INT
- 영상댓글수 (count) — INT
- 업로드일 (upload) — TEXT