+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
item_idvarchar(50)商品idNormal Index
order_idvarchar(50)订单idNormal Index
numint(10)商品购买数量
titlevarchar(200)商品标题
pricebigint(50)商品单价
total_feebigint(50)商品总金额
pic_pathvarchar(200)商品图片地址
weightsvarchar(30)总重量 单位/克

Guess You Like

MySQL Table Design okayapi_xbinstore_tb_category

MySQL Table Design okayapi_xbinstore_tb_category_image

MySQL Table Design okayapi_xbinstore_tb_category_secondary

MySQL Table Design okayapi_xbinstore_tb_hot_words

MySQL Table Design okayapi_xbinstore_tb_index_slide_ad

MySQL Table Design okayapi_xbinstore_tb_item

MySQL Table Design okayapi_xbinstore_tb_item_desc

MySQL Table Design okayapi_xbinstore_tb_item_param

MySQL Table Design okayapi_xbinstore_tb_item_param_item

MySQL Table Design okayapi_xbinstore_tb_manage_user

MySQL Table Design okayapi_xbinstore_tb_order

MySQL Table Design okayapi_xbinstore_tb_transaction_message

MySQL Table Design okayapi_xbinstore_tb_user

MySQL Table Design okayapi_xbinstore_tb_user_addr

TOP ↑