master

分支 (1)

管理

管理

master

cisco-express-pickup-system
/
kesi.sql

/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80019
 Source Host           : localhost:3306
 Source Schema         : kesi

 Target Server Type    : MySQL
 Target Server Version : 80019
 File Encoding         : 65001

 Date: 24/11/2022 16:36:06
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(0) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------

-- ----------------------------
-- Table structure for receive_order
-- ----------------------------
DROP TABLE IF EXISTS `receive_order`;
CREATE TABLE `receive_order`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '取件订单编号',
  `uid` bigint(0) NULL DEFAULT NULL COMMENT '对应用户ID',
  `aid` bigint(0) NULL DEFAULT NULL COMMENT '对应管理员ID',
  `sid` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应商品ID：这个应该可以调淘宝API去获取订单信息，因为不确定长度所以用varchar',
  `status` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '取件状态：未发货（快递公司） 未到驿站（驿站） 未取件（用户） 已取件（用户） 订单完成（14天自动修改）',
  `active` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '取件码： 9开头，方便区分是取件码还是用户码，这个取件码应该是状态为未取件才有',
  `create_time` datetime(6) NULL DEFAULT NULL COMMENT '订单创建时间',
  `finish_time` datetime(6) NULL DEFAULT NULL COMMENT '订单完成时间： 为空则设置默认值为：订单为完成',
  `logistic` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '快递单号',
  `shipper` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '快递公司的编号，如：圆通就是YTO',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 35 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of receive_order
-- ----------------------------
INSERT INTO `receive_order` VALUES (1, 1, 1, '1100000011015', '已取件', '912123151', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (2, 5, 1, '1100000011016', '已取件', '912123152', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (3, 1, 1, '1100000011017', '未取件', '912123125', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (4, 1, 1, '1100000011018', '未取件', '912123126', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (5, 1, 1, '1100000011019', '未取件', '912123127', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (6, 1, 1, '1100000011020', '未取件', '912123128', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (7, 81, 1, '1100000011021', '已取件', '912123153', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (8, 81, 1, '1100000011022', '已取件', '912123154', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (9, 81, 1, '1100000011023', '未取件', '912123133', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (10, 81, 1, '1100000011024', '未取件', '912123134', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (11, 81, 1, '1100000011025', '未取件', '912123135', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (12, 103, 1, '1100000011026', '未取件', '912123136', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (13, 103, 1, '1100000011027', '未取件', '912123137', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (14, 103, 1, '1100000011028', '未取件', '912123138', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (15, 103, 1, '1100000011029', '未取件', '912123139', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (16, 103, 1, '1100000011030', '未取件', '912123142', '2022-10-12 22:43:56.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (26, 105, 1, '1100000011030', '已取件', '912123155', '2022-11-19 15:13:47.000000', NULL, 'YT6852726878067', 'YTO');
INSERT INTO `receive_order` VALUES (27, 105, 1, '1100000011030', '未取件', '912123144', '2022-11-19 15:13:47.000000', NULL, '773187653868097', 'STO');
INSERT INTO `receive_order` VALUES (28, 105, 1, '1100000011030', '未取件', '912123145', '2022-11-19 15:13:47.000000', NULL, 'JT3017753774635', 'HTKY');
INSERT INTO `receive_order` VALUES (29, 105, 1, '1100000011030', '未取件', '912123146', '2022-11-19 15:13:47.000000', NULL, 'JT3011299281225', 'HTKY');
INSERT INTO `receive_order` VALUES (30, 105, 1, '1100000011030', '未取件', '912123147', '2022-11-19 15:13:47.000000', NULL, 'JT3010992925939', 'HTKY');
INSERT INTO `receive_order` VALUES (31, 105, 1, '1100000011030', '已取件', '912123148', '2022-11-19 15:13:47.000000', NULL, 'YT6840023428631', 'YTO');
INSERT INTO `receive_order` VALUES (32, 105, 1, '1100000011030', '已取件', '912123149', '2022-11-19 15:13:47.000000', NULL, 'YT6833102009531', 'YTO');
INSERT INTO `receive_order` VALUES (33, 105, 1, '1100000011030', '已取件', '912123150', '2022-11-19 15:13:47.000000', NULL, 'YT6784207543600', 'YTO');
INSERT INTO `receive_order` VALUES (34, 105, 1, '1100000011030', '已取件', '912123151', '2022-11-19 15:13:47.000000', NULL, '6784207543600', 'SF');

-- ----------------------------
-- Table structure for send_order
-- ----------------------------
DROP TABLE IF EXISTS `send_order`;
CREATE TABLE `send_order`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '取件订单编号',
  `uid` bigint(0) NULL DEFAULT NULL COMMENT '对应用户ID',
  `aid` bigint(0) NULL DEFAULT NULL COMMENT '对应管理员ID',
  `status` char(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '取件状态：未拿到快递（驿站） 未发货（驿站找快递公司） 未收货（取件人） 已收货（取件人） 订单完成（14天自动修改）',
  `create_time` datetime(6) NULL DEFAULT NULL COMMENT '订单创建时间',
  `finish_time` datetime(6) NULL DEFAULT NULL COMMENT '订单完成时间： 为空则设置默认值为：订单为完成',
  `receive_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件人姓名',
  `receive_phone` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件人手机号',
  `receive_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '收件人地址',
  `goods_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '寄件物品类型',
  `goods_weight` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '寄件物品重量',
  `send_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '寄件人姓名',
  `send_phone` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '寄件人手机号',
  `send_address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '寄件人地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of send_order
-- ----------------------------
INSERT INTO `send_order` VALUES (1, 81, 1, '未拿到快递', '2022-10-13 23:30:26.000000', NULL, 'll', '18211386401', '广东省-广州市-天河区-体育西路', '书籍', '10kg', '烤肉酱', '18211386402', '广东省-惠州市-惠城区江北菊花二路');
INSERT INTO `send_order` VALUES (2, 105, 1, '未拿到快递', '2022-10-13 23:30:26.000000', NULL, 'll', '18211386401', '广东省-广州市-天河区-体育西路', '电子产品', '12kg', '烤肉酱', '18211386402', '广东省-惠州市-惠城区江北菊花二路');
INSERT INTO `send_order` VALUES (3, 105, 1, '未拿到快递', '2022-10-13 23:30:26.000000', NULL, 'll', '18211386401', '广东省-广州市-天河区-体育西路', '电子产品', '12kg', '烤肉酱', '18211386402', '广东省-惠州市-惠城区江北菊花二路');
INSERT INTO `send_order` VALUES (4, 103, 1, '未拿到快递', '2022-10-13 23:30:26.000000', '2022-11-20 00:00:00.000000', 'll', '18211386401', '广东省-广州市-天河区-体育西路', '电子产品', '12kg', '烤肉酱', '18211386402', '广东省-惠州市-惠城区江北菊花二路');
INSERT INTO `send_order` VALUES (9, 103, 1, '未拿到快递', '2022-11-23 00:00:00.000000', NULL, 'll', '广东省广州市白云区东平村', '18211386406', '衣物', '15kg', '烤肉酱', '广东省-惠州市-惠城区', '18211386406');
INSERT INTO `send_order` VALUES (10, 105, 1, '未拿到快递', '2022-11-23 00:00:00.000000', NULL, 'll', '广东省-广州市-白云区', '18211386402', '日用品', '15kg', '烤肉酱', '广东省-惠州市-惠城区', '18211386406');
INSERT INTO `send_order` VALUES (11, 105, 1, '未拿到快递', '2022-11-23 00:00:00.000000', NULL, '昆克', '广东省-广州市', '18211386402', '衣物', '20kg', '烤肉酱', '广东省-惠州市-惠城区', '18211386406');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名：限定为10个以内',
  `password` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码：限定为20个以内',
  `phone` char(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号：11加上前面的区服+86 等               ',
  `address` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  `photo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像： 为空则设置默认值为：头像.png ',
  `active` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户身份码 ： 1开头 方便区分是取件码还是用户码',
  `state` char(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态：活跃 || 注销',
  `create_time` date NULL DEFAULT NULL COMMENT '注册时间',
  `role` int(0) NULL DEFAULT NULL COMMENT '身份 1: 用户 2: 普通管理员 3: 超级管理员',
  `open_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '唯一登录辨别id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'aaa', '123456', '+86-18213211231', '广东省-广州市-花都区-广州软件学院1231asdasd', 'http://localhost:15535/files/eff2754ee59549f5a179855edd474db2', '0000010221015', '活跃', '2022-10-15', 0, NULL);
INSERT INTO `user` VALUES (5, '爱缪23', '123456', '+86-18213211231', '广东省-广州市-从化区-广州软件学院', 'http://localhost:15535/files/961e66094cb04907934d6e5195dc92f1', '0000010221016', '活跃', '2022-10-12', 1, NULL);
INSERT INTO `user` VALUES (20, 'asd', '123456', '+86-18213211231', '河北省-唐山市-丰南区-1231231231asdasd', 'http://localhost:15535/files/20245f7af8d74415986e77e2b7726d3d', '0000010221018', '活跃', '2022-10-13', 0, NULL);
INSERT INTO `user` VALUES (25, 'LiSA', '123456', '+86-18213211231', '广东省-广州市-从化区-广州软件学院书新楼', 'http://localhost:15535/files/c56329051e6d45019a393cd04661539c', '0000010221021', '活跃', '2022-10-12', 1, NULL);
INSERT INTO `user` VALUES (81, 'la~', NULL, NULL, '广东省-惠州市-惠城区', 'https://thirdwx.qlogo.cn/mmopen/vi_32/mxEsqKcBYwTpaMbib2J15eFap4AUNGb0zyHlb8EGUbDibVlflg5ibIPE1BXRV0dusSo5J8xoCmbBhS0ZuSax5dcxg/132', '0312517032859', '活跃', '2022-11-20', 3, 'oV2545du-EjgXXdY1zPbZxvIJOSI');
INSERT INTO `user` VALUES (103, '1YJe09X1', NULL, '18211386405', '--', 'http://localhost:15535/files/c56329051e6d45019a393cd04661539c', '0743027098127', '活跃', '2022-11-20', 3, NULL);
INSERT INTO `user` VALUES (105, '烤肉酱', NULL, '18211386406', '广东省-惠州市-惠城区', 'http://localhost:15535/files/c56329051e6d45019a393cd04661539c', '0994589283847', '活跃', '2022-11-20', 3, NULL);
INSERT INTO `user` VALUES (109, 'aaw', '123456', '+86-18211386401', '天津市-市辖区-河东区-芜湖村', 'http://localhost:15535/files/2845cc9e32e848fd845ef928ef45aa59', NULL, '活跃', '2022-11-23', 0, NULL);

SET FOREIGN_KEY_CHECKS = 1;