youtube_analysis

Tables (7)

active_info (Untitled5)

  • active_info_idx (Key) — Primary key — NOT NULL
  • code (Field) — char
  • active_proportion (Field2) — float
  • comment_count (Field3) — int
  • view_count (Field4) — int

comment_analysis (Untitled6)

  • comment_analysis_idx (Key) — Primary key — NOT NULL
  • word_cloud_idx (Field7)
  • profile_img (Field) — char
  • nickname (Field3) — char
  • comment (Field2) — char
  • sentence (Field4) — char
  • positive (Field5) — bool

dailey_user_count (Untitled2)

  • daily_user_count_idx (Key2) — int — Primary key — NOT NULL
  • dailyuser_count (Field) — int
  • date (Field2) — date

ip_count (Untitled)

  • ip_count_idx (Field) — int — Primary key — NOT NULL
  • ip (Field1) — char
  • count (Field2) — int
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime

user_log (Untitled3)

  • user_log_idx (Key) — int — Primary key — NOT NULL
  • code (Field3) — char
  • ip (Field) — char
  • target_url (Field2) — char
  • date (Field4) — datetime
  • video_id (Field5)

word_analysis (Untitled7)

  • word_analysis_idx (Key) — Primary key — NOT NULL
  • word_cloud_idx (Field2)
  • positive_proportion (Field)
  • positive_count (Field3)
  • negative_count (Field4)

word_cloud (Untitled4)

  • word_cloud_idx (Key) — int — Primary key — NOT NULL
  • code (Field4) — char
  • word (Field2)
  • weight (Field3)