+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
okayapi_lvyou_jee_line_tao_statustinyint(4)00
line_idint(11)
okayapi_lvyou_jee_line_tao_namesvarchar(100)图片标题
opentimevarchar(50)
endtimevarchar(50)
man_priceint(11)
man_price_yufuint(11)
er_priceint(11)00
er_price_yufuint(11)
count_renint(11)
placeint(11)
sortint(11)排序

Guess You Like

MySQL Table Design okayapi_opentrip_travel_admin

MySQL Table Design okayapi_opentrip_travel_category

MySQL Table Design okayapi_opentrip_travel_order

MySQL Table Design okayapi_opentrip_travel_product

MySQL Table Design okayapi_opentrip_travel_shopcart

MySQL Table Design okayapi_opentrip_travel_user

MySQL Table Design okayapi_travel_agents

MySQL Table Design okayapi_travel_agent_users

MySQL Table Design okayapi_travel_categories

MySQL Table Design okayapi_travel_depots

MySQL Table Design okayapi_travel_depot_annuals

MySQL Table Design okayapi_travel_depot_logs

MySQL Table Design okayapi_travel_depot_staffs

MySQL Table Design okayapi_travel_depot_vouchers

MySQL Table Design okayapi_travel_devices

MySQL Table Design okayapi_travel_exist_statistics

MySQL Table Design okayapi_travel_features

MySQL Table Design okayapi_travel_groups

MySQL Table Design okayapi_travel_orders

MySQL Table Design okayapi_travel_staff_exchanges

TOP ↑