forked from kelvins-io/micro-mall-api
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathmicro_mall_order.sql
116 lines (107 loc) · 6.62 KB
/
micro_mall_order.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
/*
Navicat Premium Data Transfer
Source Server : MySQL-本地
Source Server Type : MySQL
Source Server Version : 80021
Source Host : localhost:3306
Source Schema : micro_mall_order
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 18/07/2021 13:24:56
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`tx_code` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '交易号',
`order_code` char(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '订单code',
`uid` bigint NOT NULL COMMENT '用户UID',
`order_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '下单时间',
`description` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '订单描述',
`client_ip` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客户端IP',
`device_code` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客户端设备code',
`shop_id` bigint NOT NULL COMMENT '门店ID',
`state` tinyint NOT NULL DEFAULT '0' COMMENT '订单状态，0-有效，1-锁定中，2-无效',
`pay_expire` datetime NOT NULL COMMENT '支付有效期，默认30分钟内有效',
`pay_state` tinyint NOT NULL DEFAULT '0' COMMENT '支付状态，0-未支付，1-支付中，2-支付失败，3-已支付，4-支付过期取消',
`amount` int DEFAULT NULL COMMENT '订单关联商品数量',
`money` decimal(48,4) NOT NULL DEFAULT '0.0000' COMMENT '订单总金额',
`coin_type` tinyint DEFAULT '0' COMMENT ' 订单币种，0-CNY，1-USD',
`logistics_delivery_id` int DEFAULT NULL COMMENT '物流投递ID',
`inventory_verify` tinyint DEFAULT '0' COMMENT '库存核实，0-未核实，1-核实',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `uid_index` (`uid`) USING BTREE COMMENT '用户UID索引',
KEY `shop_id_index` (`shop_id`) USING BTREE COMMENT '店铺ID索引',
KEY `create_time_index` (`create_time`) USING BTREE COMMENT '订单创建时间',
KEY `pay_expire_index` (`pay_expire`) USING BTREE COMMENT '订单支付过期时间',
KEY `pay_state_order_code_index` (`pay_state`,`order_code`) USING BTREE COMMENT '支付状态-订单号',
KEY `state,order_code_index` (`state`,`order_code`) USING BTREE COMMENT '订单状态-订单号',
KEY `inventory_verify_order_code` (`inventory_verify`,`order_code`) USING BTREE COMMENT '订单库存核实-订单号',
KEY `order_code_index` (`order_code`) USING BTREE COMMENT '订单code索引',
KEY `tx_code_order_code_index` (`tx_code`,`order_code`) USING BTREE COMMENT '交易号订单号唯一索引'
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='订单表';
-- ----------------------------
-- Table structure for order_estimate
-- ----------------------------
DROP TABLE IF EXISTS `order_estimate`;
CREATE TABLE `order_estimate` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`estimate_code` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '评论code',
`sku_code` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '商品sku',
`order_code` char(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '订单code',
`uid` bigint DEFAULT NULL COMMENT '用户uid',
`shop_id` bigint DEFAULT NULL COMMENT '店铺ID',
`content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '内容',
`star` int DEFAULT NULL COMMENT '星级',
`state` tinyint DEFAULT '0' COMMENT '状态，0-有效',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `estimate_code_shop_id` (`estimate_code`,`shop_id`) USING BTREE COMMENT '评论code-店铺ID',
KEY `uid_index` (`uid`) USING BTREE COMMENT '用户ID',
KEY `shop_id_index` (`shop_id`) USING BTREE COMMENT '店铺ID',
KEY `order_code_index` (`order_code`) USING BTREE COMMENT '订单code'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='订单评论表';
-- ----------------------------
-- Table structure for order_scene_shop
-- ----------------------------
DROP TABLE IF EXISTS `order_scene_shop`;
CREATE TABLE `order_scene_shop` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`order_code` char(40) DEFAULT NULL COMMENT '订单code',
`shop_id` bigint DEFAULT NULL COMMENT '店铺ID',
`shop_name` varchar(512) DEFAULT NULL COMMENT '店铺名',
`shop_area_code` varchar(255) DEFAULT NULL COMMENT '店铺区域code',
`shop_address` text COMMENT '店铺地址',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='订单店铺信息';
-- ----------------------------
-- Table structure for order_sku
-- ----------------------------
DROP TABLE IF EXISTS `order_sku`;
CREATE TABLE `order_sku` (
`id` bigint NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`order_code` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '对应订单code',
`shop_id` bigint NOT NULL COMMENT '店铺ID',
`sku_code` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '商品sku',
`price` decimal(32,16) NOT NULL DEFAULT '0.0000000000000000' COMMENT '商品单价',
`amount` int NOT NULL COMMENT '商品数量',
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '商品名称',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE,
KEY `name_index` (`name`) USING BTREE COMMENT '商品名称索引',
KEY `shop_id_index` (`shop_id`) USING BTREE COMMENT '店铺索引',
KEY `shop_order_code_index` (`shop_id`,`order_code`) USING BTREE COMMENT '店铺-订单code',
KEY `order_code_index` (`order_code`) USING BTREE COMMENT '订单code索引'
) ENGINE=InnoDB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8 COMMENT='订单商品明细';
SET FOREIGN_KEY_CHECKS = 1;