抖音mysql_抖音排行榜数据库设计方案
抖音排行榜抖音实在太火了，自己喜欢的达人又多，很多为了商业对接的目的下，很多是凭感觉刷视频，但是这样太浪费时间，选择方式粗放，我试着能否通过做张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;
抖音排行榜抖音实在太火了，自己喜欢的达人又多，很多为了商业对接的目的下，很多是凭感觉刷视频，但是这样太浪费时间，选择方式粗放，我试着能否通过做张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;