+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_lvyou_jee_line_price:/tablelist/okayapi_lvyou_jee_line_price.html


-- MySQL Table okayapi_lvyou_jee_line_price
-- From: OkayAPI.com
CREATE TABLE `okayapi_lvyou_jee_line_price` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `line_id` int(11) NULL COMMENT '',
    `price_type` int(11) NULL COMMENT '价格类型,1指定日期,2起始日期和结束日期,3指定星期,4基本',
    `price_date` int(11) NULL COMMENT '当前价格日期',
    `price_date_end` int(11) NULL COMMENT '价格类型为阶段类型时的结束时间',
    `RACKRATE` decimal(20,2) NULL COMMENT '门市价',
    `price_adult` decimal(20,2) NULL COMMENT '成人价',
    `price_children` decimal(20,2) NULL COMMENT '儿童价',
    KEY `line_id` (`line_id`),
    KEY `price_type` (`price_type`),
    KEY `price_date` (`price_date`),
    KEY `price_date_end` (`price_date_end`),
    KEY `RACKRATE` (`RACKRATE`),
    KEY `price_adult` (`price_adult`),
    KEY `price_children` (`price_children`),
    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-7 of 7 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
line_idint(11)
price_typeint(11)价格类型,1指定日期,2起始日期和结束日期,3指定星期,4基本
price_dateint(11)当前价格日期
price_date_endint(11)价格类型为阶段类型时的结束时间
RACKRATEdecimal(20,2)门市价
price_adultdecimal(20,2)成人价
price_childrendecimal(20,2)儿童价

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 ↑