MySQL Create Table SQL
Table Structure: okayapi_xbinstore_tb_order_item:/tablelist/okayapi_xbinstore_tb_order_item.html
-- MySQL Table okayapi_xbinstore_tb_order_item
-- From: OkayAPI.com
CREATE TABLE `okayapi_xbinstore_tb_order_item` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`item_id` varchar(50) NULL COMMENT '商品id',
`order_id` varchar(50) NULL COMMENT '订单id',
`num` int(10) NULL COMMENT '商品购买数量',
`title` varchar(200) NULL COMMENT '商品标题',
`price` bigint(50) NULL COMMENT '商品单价',
`total_fee` bigint(50) NULL COMMENT '商品总金额',
`pic_path` varchar(200) NULL COMMENT '商品图片地址',
`weights` varchar(30) NULL COMMENT '总重量 单位/克',
KEY `item_id` (`item_id`),
KEY `order_id` (`order_id`),
KEY `num` (`num`),
KEY `title` (`title`),
KEY `price` (`price`),
KEY `total_fee` (`total_fee`),
KEY `pic_path` (`pic_path`),
KEY `weights` (`weights`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'B2C商城-订单项目';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
item_id | varchar(50) | 否 | 商品id | Normal Index | ||
order_id | varchar(50) | 否 | 订单id | Normal Index | ||
num | int(10) | 是 | 商品购买数量 | |||
title | varchar(200) | 是 | 商品标题 | |||
price | bigint(50) | 是 | 商品单价 | |||
total_fee | bigint(50) | 是 | 商品总金额 | |||
pic_path | varchar(200) | 是 | 商品图片地址 | |||
weights | varchar(30) | 是 | 总重量 单位/克 |