MySQL Create Table SQL
Table Structure: okayapi_opentrip_travel_shopcart：/tablelist/okayapi_opentrip_travel_shopcart.html
-- MySQL Table okayapi_opentrip_travel_shopcart
-- From: OkayAPI.com
CREATE TABLE `okayapi_opentrip_travel_shopcart` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`user_id` int(10) NOT NULL COMMENT '购买者ID',
`product_id` int(10) NOT NULL COMMENT '购买商品ID',
`num` tinyint(3) NOT NULL COMMENT '购买商品数量',
KEY `user_id` (`user_id`),
KEY `product_id` (`product_id`),
KEY `num` (`num`),
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-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| user_id | int(10) | 否 | 购买者ID | |||
| product_id | int(10) | 否 | 购买商品ID | |||
| num | tinyint(3) | 否 | 购买商品数量 |
