yt_db

Tables (3)

Untitled (yt_channel_category)

  • category — VARCHAR(200) — Primary key — NOT NULL
  • URL (url) — VARCHAR(200)

Untitled (channel_info)

  • Key (channel_name) — VARCHAR(200) — Primary key — NOT NULL
  • category — VARCHAR(200) — Foreign key → Untitled.category — NOT NULL
  • youtuberme_url — VARCHAR(200)
  • video_count (total_video_count) — int(255)
  • channel_started_date (started) — Date
  • subsriber_count (subscribers) — int(255)
  • youtube_url (yt_url) — VARCHAR(200)
  • total_views — int(255)
  • country — VARCHAR(50)

Untitled (shorts_info)

  • Key (channel_name) — VARCHAR(200) — Foreign key → Untitled.Key — NOT NULL
  • youtube_url (yt_url) — VARCHAR(200)
  • subsribers (subscribers) — int(255)
  • check date (check_date) — Date
  • released date (released_date) — Date
  • is posted (is_posted) — int(2)
  • shorts name (shorts_name) — VARCHAR(200)
  • description (discription) — VARCHAR(200)
  • like (likes) — int(255)
  • views — int(255)
  • comments (comments_num) — int(255)
  • shorts_url — VARCHAR(200)