크롤링

테이블 (5)

Dimension_Video3 (Untitled5)

  • Video_Id (비디오ID) — 기본 키 — NOT NULL
  • Video_title (비디오제목)
  • Video_description (비디오설명)
  • Channel_ID (채널ID)
  • Pub_date (동영상게시일)
  • Brand (브랜드)
  • Field (채널장르)

Fact_VideoResponse (Untitled2)

  • Video_Id (비디오ID2) — 외래 키 → Dimension_Video3.Video_Id — NOT NULL
  • Category_Id (카테고리ID)
  • Tag (태그)
  • View_counts (조회수)
  • Like_counts (좋아요수)
  • Dislike_counts (싫어요수)
  • Comments_counts (댓글수)
  • Timestamp (크롤링일시)

Fact_channelResponse (Untitled)

  • Channel_ID (채널ID2) — 외래 키 → dim_ch.Channel_ID — NOT NULL
  • View_count (조회수)
  • Subscribe_counts (구독자수)
  • Video_counts (비디오개수)
  • Timestamp (크롤링일시)

Fact_comment (Untitled3)

  • Video_Id (비디오ID2) — 외래 키 → Dimension_Video3.Video_Id — NOT NULL
  • time (시간)
  • comment (댓글)
  • username (사용자)
  • likes (좋아요)
  • threadids (댓글ID)
  • type (타입)

dim_ch (Untitled4)

  • Channel_ID (채널ID) — 기본 키 — NOT NULL
  • Channel_Title (채널명)
  • Channel_genre (채널장르)
  • Brand (브랜드)
  • Published (채널개설일시)