博客

抖音排行榜抖音实在太火了，自己喜欢的达人又多，很多为了商业对接的目的下，很多是凭感觉刷视频，但是这样太浪费时间，选择方式粗放，我试着能否通过做张category的rank来对比同类目的达人间的竞争力。

达人信息表格创建

CREATE TABLE PERSON_INFO(

id int unsigned auto_increment,

category varchar(10) not nUll,

local varchar(10) null,

grade int not null,

Nickname varchar(20) not null,

Short_id varchar(20) not null,

Icon varchar(50) not null,

Signature varchar(100) not null,

total_favorited int not null,

followers_count int not null,

relay int not null,

primary key(id))ENGINE=InnoDB DEFAULT CHARSET=utf8;

视频信息表格创建

CREATE TABLE VEDIO_INFO(

id int unsigned auto_increment,

create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

viedo_id int not null,

video_url varchar(50) not null,

video_title varchar(50) not null,

video_page varchar(50) not null,

video_fovrited varchar(10) not null,

video_comment_count varchar(10) not null,

primary key(id))ENGINE=InnoDB DEFAULT CHARSET=utf8;

视频评价

CREATE TABLE VEDIO_comment(

video_id int(50) not null,

create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

fans_name varchar(20) not null,

fans_comment varchar(200) not null,

primary key(video_id))ENGINE=InnoDB DEFAULT CHARSET=utf8;