MySQL Create Table SQL
Table Structure: okayapi_lvyou_jee_line_tao:/tablelist/okayapi_lvyou_jee_line_tao.html
-- MySQL Table okayapi_lvyou_jee_line_tao
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_tao` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`okayapi_lvyou_jee_line_tao_status` tinyint(4) NULL DEFAULT '0' COMMENT '',
`line_id` int(11) NULL COMMENT '',
`okayapi_lvyou_jee_line_tao_names` varchar(100) NULL COMMENT '图片标题',
`opentime` varchar(50) NULL COMMENT '',
`endtime` varchar(50) NULL COMMENT '',
`man_price` int(11) NULL COMMENT '',
`man_price_yufu` int(11) NULL COMMENT '',
`er_price` int(11) NULL DEFAULT '0' COMMENT '',
`er_price_yufu` int(11) NULL COMMENT '',
`count_ren` int(11) NULL COMMENT '',
`place` int(11) NULL COMMENT '',
`sort` int(11) NULL COMMENT '排序',
KEY `okayapi_lvyou_jee_line_tao_status` (`okayapi_lvyou_jee_line_tao_status`),
KEY `line_id` (`line_id`),
KEY `okayapi_lvyou_jee_line_tao_names` (`okayapi_lvyou_jee_line_tao_names`),
KEY `opentime` (`opentime`),
KEY `endtime` (`endtime`),
KEY `man_price` (`man_price`),
KEY `man_price_yufu` (`man_price_yufu`),
KEY `er_price` (`er_price`),
KEY `er_price_yufu` (`er_price_yufu`),
KEY `count_ren` (`count_ren`),
KEY `place` (`place`),
KEY `sort` (`sort`),
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-12 of 12 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
okayapi_lvyou_jee_line_tao_status | tinyint(4) | 0 | 是 | 0 | ||
line_id | int(11) | 否 | ||||
okayapi_lvyou_jee_line_tao_names | varchar(100) | 是 | 图片标题 | |||
opentime | varchar(50) | 是 | ||||
endtime | varchar(50) | 是 | ||||
man_price | int(11) | 是 | ||||
man_price_yufu | int(11) | 是 | ||||
er_price | int(11) | 0 | 是 | 0 | ||
er_price_yufu | int(11) | 是 | ||||
count_ren | int(11) | 是 | ||||
place | int(11) | 是 | ||||
sort | int(11) | 是 | 排序 |