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