youtube_market

Tables (14)

Copy Of Copy Of Copy Of Copy Of channel_info22 (Video_commauthor)

  • Key (AUTHOR_ID) — String(255) — Primary key — NOT NULL
  • Field5 (AUTHOR_NAME) — String(255)

Copy Of Copy Of Copy Of channel_info (Video_map_group_info)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Key (VD_ID) — String(30) — Foreign key → Copy Of channel_info3.Key — NOT NULL
  • Key (GR_ID) — Integer — Foreign key → Copy Of Copy Of channel_info2.Key — NOT NULL

Copy Of Copy Of Copy Of channel_info22 (Video_comment)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Key (VD_ID) — String(30) — Foreign key → Untitled.Key — NOT NULL
  • Key (AUTHOR_ID) — String(255) — Foreign key → Copy Of Copy Of Copy Of Copy Of channel_info22.Key — NOT NULL
  • Field5 (KIND) — String(255)
  • Field6 (textOriginal) — String(255)
  • Field (LIKECOUNT) — Integer
  • Field (REPLYCOUNT) — Integer — NOT NULL
  • Field (PUBLISHTIME) — DateTime — NOT NULL
  • Field (UPDATETIME) — DateTime — NOT NULL

Copy Of Copy Of Copy Of channel_info222 (Video_summarized)

  • Key (ID) — String(30) — Foreign key → Copy Of channel_info3.Key — NOT NULL
  • Field6 (ORIGINALCC) — String(255)
  • Field (ENCC) — String(255)
  • Field5 (KEYWORDS) — String(255)
  • Field (SUMMARY) — String(255)
  • Field (UPDATETIME) — DATETIME — NOT NULL

Copy Of Copy Of channel_info (Channel_map_group_info)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Key (CH_ID) — String(30) — Foreign key → channel_info.Key — NOT NULL
  • Key (GR_ID) — Integer — Foreign key → Copy Of channel_info.Key — NOT NULL

Copy Of Copy Of channel_info2 (Video_Group)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Field2 (TITLE) — String(255) — NOT NULL
  • Field3 (DESCRIPTION) — String(255)
  • Field (TRACKING_TF) — Integer

Copy Of Copy Of channel_info22 (Video_statistics)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Key (VD_ID) — String(30) — Foreign key → Untitled.Key — NOT NULL
  • Field6 (VIEWCOUNT) — Integer
  • Field (LIKECOUNT) — Integer
  • Field5 (COMMENTCOUNT) — Integer
  • Field (UPDATETIME) — DateTime — NOT NULL

Copy Of Copy Of channel_info3 (Video_recommend)

  • Key (ID) — String(30) — Foreign key → channel_info.Key — NOT NULL
  • Key (CH_ID) — String(30) — Foreign key → Copy Of channel_info3.Key — NOT NULL
  • Field (UPDATETIME) — DateTime — NOT NULL

Copy Of channel_info (Channel_Group)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Field2 (TITLE) — String(255) — NOT NULL
  • Field3 (DESCRIPTION) — String(255)
  • Field (TRACKING_TF) — Integer

Copy Of channel_info2 (Channel_statistics)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Key (CH_ID) — String(30) — Foreign key → channel_info.Key — NOT NULL
  • Field5 (SUBSCRIBERCOUNTS) — Integer
  • Field (VIDEOCOUNT) — Integer
  • Field6 (VIEWCOUNT) — Integer
  • Field (UPDATETIME) — DateTime — NOT NULL

Copy Of channel_info3 (Video_info)

  • Key (ID) — String(30) — Primary key — NOT NULL
  • Key (CH_ID) — String(30) — Foreign key → channel_info.Key — NOT NULL
  • Field (KIND) — String(255) — NOT NULL
  • Field2 (TITLE) — String(255) — NOT NULL
  • Field3 (DESCRIPTION) — String(255)
  • Field (THUMBNAILS) — String(255)
  • Field (REASON) — String(255) — NOT NULL
  • Field (PUBLISHTIME) — DateTime — NOT NULL
  • Field (UPDATETIME) — DateTime — NOT NULL

Copy Of channel_info4 (Datalab_catinfo)

  • Key (ID) — Integer — Primary key — NOT NULL
  • Field (CATNM_LVL1) — String(255) — NOT NULL
  • Field2 (CATNM_LVL2) — String(255)
  • Field6 (CATNM_LVL3) — String(255)
  • Field3 (CATNM_LVL4) — String(255)
  • Field4 (CATNM) — String(255) — NOT NULL

Untitled (Video_dtl)

  • Key (ID) — String(30) — Foreign key → Copy Of channel_info3.Key — NOT NULL
  • Field (KIND) — String(255) — NOT NULL
  • Field2 (TITLE) — String(255) — NOT NULL
  • Field3 (DESCRIPTION) — String(255)
  • Field (DURATION) — String — NOT NULL
  • Field (CAPTION) — Integer — NOT NULL
  • Field (TAGS) — String(255)
  • Field4 (LIVECONTENT) — String(10)
  • Field (THUMBNAILS) — String(255)
  • Field (VIEWCOUNT) — Integer
  • Field (LIKECOUNT) — Integer
  • Field2 (COMMENTCOUNT) — Integer
  • Field3 (LIVEVIEWERS) — Integer
  • Field5 (LOC_TITLE) — String(255)
  • Field6 (LOC_DESCRIPTION) — String(255)
  • Field (PUBLISHTIME) — DateTime — NOT NULL
  • Field (LIVESTARTTIME) — DateTime
  • Field2 (LIVEENDTIME) — DateTime
  • Field (UPDATETIME) — DateTime — NOT NULL

channel_info (Channel_info)

  • Key (ID) — String(30) — Primary key — NOT NULL
  • Field (KIND) — String(255) — NOT NULL
  • Field2 (TITLE) — String(255) — NOT NULL
  • Field3 (DESCRIPTION) — String(255)
  • Field4 (KEYWORDS) — String(255)
  • Field (VIDEOCOUNT) — Integer
  • Field5 (SUBSCRIBERCOUNTS) — Integer
  • Field6 (VIEWCOUNT) — Integer
  • Field (THUMBNAILS) — String(255)
  • Field (LOC_TITLE) — String(255)
  • Field (LOC_DESCRIPTION) — String(255)
  • Field (PUBLISHTIME) — DateTime — NOT NULL
  • Field (UPDATETIME) — DateTime — NOT NULL