+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
video_titlevarchar(255)视频标题世界杯直播
video_linkvarchar(1024)视频播放链接 http://x.okayapi.com/video/123
video_thumbnailvarchar(1024)视频截图链接http://admin.okayapi.com/images/model/m5.jpg
video_durationint(10)0视频时长,单位:秒 60
video_createddatetime视频创建时间 2018-08-08 08:08:08
video_descriptionvarchar(2048)视频描述 这是一段精彩的描述……
video_view_timesint(10)0总播放数 888

Guess You Like

MySQL Table Design okayapi_material_goods

TOP ↑