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