+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_tea_order:/tablelist/okayapi_tea_order.html


-- MySQL Table okayapi_tea_order
-- From: OkayAPI.com
CREATE TABLE `okayapi_tea_order` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `order_img` varchar(100) NULL COMMENT '封面照片',
    `order_good_id` int(10) NULL COMMENT '商品id',
    `order_goods_num` int(10) NULL COMMENT '购买数量',
    `order_identify` varchar(255) NULL COMMENT '用户唯一标识',
    `order_mobile` varchar(20) NULL COMMENT '购买者联系方式',
    `order_remark` varchar(255) NULL COMMENT '订单备注',
    `order_goods` varchar(255) NULL COMMENT '购买内容与规格参数',
    `order_price` varchar(255) NULL COMMENT '商品单价(单位元)',
    `order_location` varchar(255) NULL COMMENT '订单送货地址',
    `order_status` varchar(255) NULL COMMENT '订单状态(0表示取消订单,1表示进行中,2表示已完成,3待付款)',
    `order_time` varchar(50) NULL COMMENT '下单时间',
    `order_number` int(15) NULL COMMENT '订单号(流水号,唯一)',
    `order_buyer` varchar(255) NULL COMMENT '购买者',
    KEY `order_img` (`order_img`),
    KEY `order_good_id` (`order_good_id`),
    KEY `order_goods_num` (`order_goods_num`),
    KEY `order_identify` (`order_identify`),
    KEY `order_mobile` (`order_mobile`),
    KEY `order_remark` (`order_remark`),
    KEY `order_goods` (`order_goods`),
    KEY `order_price` (`order_price`),
    KEY `order_location` (`order_location`),
    KEY `order_status` (`order_status`),
    KEY `order_time` (`order_time`),
    KEY `order_number` (`order_number`),
    KEY `order_buyer` (`order_buyer`),
    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-13 of 13 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
order_imgvarchar(100)封面照片
order_good_idint(10)商品id
order_goods_numint(10)购买数量
order_identifyvarchar(255)用户唯一标识
order_mobilevarchar(20)购买者联系方式
order_remarkvarchar(255)订单备注
order_goodsvarchar(255)购买内容与规格参数
order_pricevarchar(255)商品单价(单位元)
order_locationvarchar(255)订单送货地址
order_statusvarchar(255)订单状态(0表示取消订单,1表示进行中,2表示已完成,3待付款)
order_timevarchar(50)下单时间
order_numberint(15)订单号(流水号,唯一)
order_buyervarchar(255)购买者

Guess You Like

MySQL Table Design okayapi_logs

MySQL Table Design okayapi_app_version

MySQL Table Design okayapi_tea

MySQL Table Design okayapi_tea_swiper

MySQL Table Design okayapi_tea_moment

MySQL Table Design okayapi_tea_user

MySQL Table Design okayapi_tea_shopcar

MySQL Table Design okayapi_zheng_cms_article

MySQL Table Design okayapi_zheng_cms_article_category

MySQL Table Design okayapi_zheng_cms_article_tag

MySQL Table Design okayapi_zheng_cms_category

MySQL Table Design okayapi_zheng_cms_comment

MySQL Table Design okayapi_zheng_cms_page

MySQL Table Design okayapi_zheng_cms_setting

MySQL Table Design okayapi_zheng_cms_system

MySQL Table Design okayapi_zheng_cms_tag

MySQL Table Design okayapi_zheng_cms_topic

MySQL Table Design okayapi_zheng_pay_in_order

MySQL Table Design okayapi_zheng_pay_in_order_detail

MySQL Table Design okayapi_zheng_pay_mch

TOP ↑