okayapi_article_ad - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_article_ad：/tablelist/okayapi_article_ad.html


-- MySQL Table okayapi_article_ad
-- From: OkayAPI.com
CREATE TABLE `okayapi_article_ad` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(30) NOT NULL COMMENT '标题',
    `cover` varchar(100) NOT NULL COMMENT '图片',
    `location_id` int(11) NOT NULL DEFAULT '0' COMMENT '广告位ID',
    `silder_text` varchar(150) NOT NULL COMMENT '图片描述',
    `start_time` int(10) NOT NULL DEFAULT '0' COMMENT '开始时间',
    `end_time` int(10) NOT NULL DEFAULT '0' COMMENT '结束时间',
    `jump_link` varchar(150) NOT NULL COMMENT '跳转链接',
    `jump_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '跳转方式[1:新标签; 2:当前页]',
    `sort` int(10) NOT NULL DEFAULT '0' COMMENT '优先级',
    `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '状态',
    KEY `title` (`title`),
    KEY `cover` (`cover`),
    KEY `location_id` (`location_id`),
    KEY `silder_text` (`silder_text`),
    KEY `start_time` (`start_time`),
    KEY `end_time` (`end_time`),
    KEY `jump_link` (`jump_link`),
    KEY `jump_type` (`jump_type`),
    KEY `sort` (`sort`),
    KEY `status` (`status`),
    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-10 of 10 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
title	varchar(30)		否	标题
cover	varchar(100)		否	图片
location_id	int(11)	0	否	广告位ID	0
silder_text	varchar(150)		否	图片描述
start_time	int(10)	0	否	开始时间	0
end_time	int(10)	0	否	结束时间	0
jump_link	varchar(150)		否	跳转链接
jump_type	tinyint(4)	1	否	跳转方式[1:新标签; 2:当前页]	1
sort	int(10)	0	否	优先级	0
status	tinyint(4)	1	否	状态	1