MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_advert:/tablelist/okayapi_lvyou_jee_advert.html
-- MySQL Table okayapi_lvyou_jee_advert
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_advert` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(50) NOT NULL COMMENT '',
`area_id` int(11) NOT NULL COMMENT '',
`okayapi_lvyou_jee_advert_types` tinyint(1) NOT NULL COMMENT '',
`start_time` int(11) NOT NULL COMMENT '',
`end_time` int(11) NOT NULL COMMENT '',
`pic` varchar(255) NOT NULL COMMENT '',
`s_pic` varchar(255) NOT NULL COMMENT '',
`url` varchar(255) NOT NULL COMMENT '',
`width` int(11) NOT NULL COMMENT '',
`height` int(11) NOT NULL COMMENT '',
`hits` int(11) NOT NULL DEFAULT '0' COMMENT '',
`sort` int(11) NOT NULL DEFAULT '0' COMMENT '',
`okayapi_lvyou_jee_advert_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '',
KEY `title` (`title`),
KEY `area_id` (`area_id`),
KEY `okayapi_lvyou_jee_advert_types` (`okayapi_lvyou_jee_advert_types`),
KEY `start_time` (`start_time`),
KEY `end_time` (`end_time`),
KEY `pic` (`pic`),
KEY `s_pic` (`s_pic`),
KEY `url` (`url`),
KEY `width` (`width`),
KEY `height` (`height`),
KEY `hits` (`hits`),
KEY `sort` (`sort`),
KEY `okayapi_lvyou_jee_advert_status` (`okayapi_lvyou_jee_advert_status`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'lvyou旅游-广告管理';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-13 of 13 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
title | varchar(50) | 否 | ||||
area_id | int(11) | 否 | ||||
okayapi_lvyou_jee_advert_types | tinyint(1) | 是 | ||||
start_time | int(11) | 是 | ||||
end_time | int(11) | 是 | ||||
pic | varchar(255) | 是 | ||||
s_pic | varchar(255) | 是 | ||||
url | varchar(255) | 是 | ||||
width | int(11) | 是 | ||||
height | int(11) | 是 | ||||
hits | int(11) | 0 | 否 | 0 | ||
sort | int(11) | 0 | 否 | 0 | ||
okayapi_lvyou_jee_advert_status | tinyint(4) | 1 | 否 | 1 |