okayapi_tea_shopcar - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_tea_shopcar：/tablelist/okayapi_tea_shopcar.html


-- MySQL Table okayapi_tea_shopcar
-- From: OkayAPI.com
CREATE TABLE `okayapi_tea_shopcar` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `car_identify_new` varchar(255) NULL COMMENT '唯一标识头像加id',
    `good_price` varchar(255) NULL COMMENT '总价',
    `good_title` varchar(255) NULL COMMENT '茶的标题',
    `good_img` varchar(255) NULL COMMENT '购物车商品的图片',
    `tea_id` int(10) NULL COMMENT '茶的id',
    `user_identify` varchar(255) NULL COMMENT '用户的唯一标识',
    KEY `car_identify_new` (`car_identify_new`),
    KEY `good_price` (`good_price`),
    KEY `good_title` (`good_title`),
    KEY `good_img` (`good_img`),
    KEY `tea_id` (`tea_id`),
    KEY `user_identify` (`user_identify`),
    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	IS NULL	Field Comment
car_identify_new	varchar(255)	是	唯一标识头像加id
good_price	varchar(255)	是	总价
good_title	varchar(255)	是	茶的标题
good_img	varchar(255)	是	购物车商品的图片
tea_id	int(10)	是	茶的id
user_identify	varchar(255)	是	用户的唯一标识