MySQL Create Table SQL
Table Structure: okayapi_opentrip_travel_order:/tablelist/okayapi_opentrip_travel_order.html
-- MySQL Table okayapi_opentrip_travel_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_opentrip_travel_order` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL COMMENT '购买者用户ID',
`product` text NOT NULL COMMENT '商品信息',
`address` text NOT NULL COMMENT '收件人信息',
`price` decimal(10,2) NOT NULL COMMENT '订单价格',
`cancel` enum('yes','no') NOT NULL COMMENT '是否取消',
`payment` enum('yes','no') NOT NULL COMMENT '是否支付',
KEY `user_id` (`user_id`),
KEY `product` (`product`),
KEY `address` (`address`),
KEY `price` (`price`),
KEY `cancel` (`cancel`),
KEY `payment` (`payment`),
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-6 of 6 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
user_id | int(10) | 否 | 购买者用户ID | |||
product | text | 否 | 商品信息 | |||
address | text | 否 | 收件人信息 | |||
price | decimal(10,2) | 否 | 订单价格 | |||
cancel | enum('yes','no') | 否 | 是否取消 | |||
payment | enum('yes','no') | 否 | 是否支付 |