MySQL Create Table SQL
Table Structure: okayapi_video:/tablelist/okayapi_video.html
-- MySQL Table okayapi_video
-- From: OkayAPI.com
CREATE TABLE `okayapi_video` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`video_title` varchar(255) NULL COMMENT '视频标题',
`video_link` varchar(1024) NULL COMMENT '视频播放链接 ',
`video_thumbnail` varchar(1024) NULL COMMENT '视频截图链接',
`video_duration` int(10) NULL DEFAULT '0' COMMENT '视频时长,单位:秒 ',
`video_created` datetime NULL COMMENT '视频创建时间 ',
`video_description` varchar(2048) NULL COMMENT '视频描述 ',
`video_view_times` int(10) NULL DEFAULT '0' COMMENT '总播放数 ',
KEY `video_title` (`video_title`),
KEY `video_link` (`video_link`),
KEY `video_thumbnail` (`video_thumbnail`),
KEY `video_duration` (`video_duration`),
KEY `video_created` (`video_created`),
KEY `video_description` (`video_description`),
KEY `video_view_times` (`video_view_times`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '视频数据';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-7 of 7 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
video_title | varchar(255) | 是 | 视频标题 | 世界杯直播 | ||
video_link | varchar(1024) | 是 | 视频播放链接 | http://x.okayapi.com/video/123 | ||
video_thumbnail | varchar(1024) | 是 | 视频截图链接 | http://admin.okayapi.com/images/model/m5.jpg | ||
video_duration | int(10) | 0 | 是 | 视频时长,单位:秒 | 60 | |
video_created | datetime | 是 | 视频创建时间 | 2018-08-08 08:08:08 | ||
video_description | varchar(2048) | 是 | 视频描述 | 这是一段精彩的描述…… | ||
video_view_times | int(10) | 0 | 是 | 总播放数 | 888 |