/*
 Navicat Premium Data Transfer

 Source Server         : 123
 Source Server Type    : MySQL
 Source Server Version : 80017
 Source Host           : localhost:3306
 Source Schema         : zk_express_delivery

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

 Date: 26/03/2022 21:18:43
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for address
-- ----------------------------
DROP TABLE IF EXISTS `address`;
CREATE TABLE `address`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收货人姓名',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '收货人电话',
  `prov` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省',
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '城',
  `area` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '区',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '详细地址',
  `status` tinyint(255) NULL DEFAULT 0 COMMENT '是否为默认地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of address
-- ----------------------------
INSERT INTO `address` VALUES (2, '张三', '13698987300', '江西省', '南昌市', '青云谱区', '江西理工大学南昌校区，双港东大街', 1);
INSERT INTO `address` VALUES (5, '王五', '12311242123', '浙江省', '宁波市', '江北区', '江西理工大学南昌校区，双港东大街', 0);

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company`  (
  `id` int(255) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '快递公司名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of company
-- ----------------------------
INSERT INTO `company` VALUES (1, '顺丰快递');
INSERT INTO `company` VALUES (2, '韵达快递');
INSERT INTO `company` VALUES (3, '赤兔快递');
INSERT INTO `company` VALUES (4, '圆通快递');
INSERT INTO `company` VALUES (5, '中通快递');
INSERT INTO `company` VALUES (6, '邮政EMS');
INSERT INTO `company` VALUES (7, '京东快递');
INSERT INTO `company` VALUES (8, '申通快递');
INSERT INTO `company` VALUES (9, '天天快递');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品名称',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品类别',
  `weight` float(10, 1) NULL DEFAULT NULL COMMENT '总量（kg）',
  `describes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (1, '洗衣粉', '1', 2.2, '家用洗衣粉');
INSERT INTO `goods` VALUES (2, '辣条', '2', NULL, '特辣');
INSERT INTO `goods` VALUES (3, '文档', '3', 1.0, '文档加密');
INSERT INTO `goods` VALUES (4, '1231', '1', 1.0, '1');
INSERT INTO `goods` VALUES (5, '手机', '1', 1.0, '1');
INSERT INTO `goods` VALUES (6, '摄像机', '5', 3.0, '贵');
INSERT INTO `goods` VALUES (7, '123', '1', 1.0, '123');
INSERT INTO `goods` VALUES (8, '2313', '1', 12.0, '123');

-- ----------------------------
-- Table structure for goods_type
-- ----------------------------
DROP TABLE IF EXISTS `goods_type`;
CREATE TABLE `goods_type`  (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods_type
-- ----------------------------
INSERT INTO `goods_type` VALUES (1, '日用品');
INSERT INTO `goods_type` VALUES (2, '食品');
INSERT INTO `goods_type` VALUES (3, '文件');
INSERT INTO `goods_type` VALUES (4, '衣物');
INSERT INTO `goods_type` VALUES (5, '数码产品');
INSERT INTO `goods_type` VALUES (6, '其他');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '快递单号（4位数）',
  `company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '快递的收录公司',
  `user_id` int(255) NULL DEFAULT NULL COMMENT '用户id',
  `good_id` int(255) NULL DEFAULT NULL COMMENT '物品id',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '快递的取件码',
  `gmt_create` datetime(6) NULL DEFAULT NULL COMMENT '快递的入库时间',
  `gmt_outtime` datetime(6) NULL DEFAULT NULL COMMENT '快遞的出库时间',
  `status` tinyint(1) NULL DEFAULT NULL COMMENT '快遞的状态',
  `sysphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '进行信息录入的管理员电话',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名字',
  `address_id` int(11) NULL DEFAULT NULL COMMENT '收货地址id',
  `userphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户地址',
  `describes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '描述信息',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1, '1001', '顺丰快递', 1, 1, '031811', '2022-03-18 21:07:37.000000', NULL, 1, '13696542034', NULL, NULL, NULL, NULL);
INSERT INTO `orders` VALUES (3, '1003', '韵达快递', 2, 1, '5456203', '2022-03-20 13:02:15.000000', NULL, 0, '1369654208', NULL, NULL, NULL, NULL);
INSERT INTO `orders` VALUES (4, '0321', '邮政EMS', 1, 1, '03211', '2022-03-21 14:23:53.941000', NULL, 0, NULL, '麻子', 2, '13954682422', '快速');
INSERT INTO `orders` VALUES (5, '0321', '京东快递', 1, 1, '03211', '2022-03-21 14:48:28.526000', NULL, 0, NULL, '芙蓉', 2, '123123123', '123');
INSERT INTO `orders` VALUES (6, '0321', '京东快递', 1, 5, '03211', '2022-03-21 14:49:17.720000', NULL, 0, NULL, '张三', 2, '123', '123');
INSERT INTO `orders` VALUES (8, '0321', '京东快递', 1, 7, '03211', '2022-03-21 14:58:16.180000', NULL, 0, NULL, '张三', 2, '1', '1');
INSERT INTO `orders` VALUES (9, '0321', '邮政EMS', 1, 8, '03211', '2022-03-21 14:58:52.307000', NULL, 0, NULL, '张三1', 2, '2', '1');

-- ----------------------------
-- Table structure for prov
-- ----------------------------
DROP TABLE IF EXISTS `prov`;
CREATE TABLE `prov`  (
  `id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '省份名称',
  `type` int(11) NULL DEFAULT NULL COMMENT '类型，0为省，1为市，2为县',
  `person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '父id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of prov
-- ----------------------------
INSERT INTO `prov` VALUES (1, '江西省', 0, '0');
INSERT INTO `prov` VALUES (2, '浙江省', 0, '0');
INSERT INTO `prov` VALUES (3, '湖南省', 0, '0');
INSERT INTO `prov` VALUES (4, '南昌市', 1, '1');
INSERT INTO `prov` VALUES (5, '抚州市', 1, '1');
INSERT INTO `prov` VALUES (6, '赣州市', 1, '1');
INSERT INTO `prov` VALUES (7, '东湖区', 2, '4');
INSERT INTO `prov` VALUES (8, '西湖区', 2, '4');
INSERT INTO `prov` VALUES (9, '青云谱区', 2, '4');
INSERT INTO `prov` VALUES (10, '进贤区', 2, '4');
INSERT INTO `prov` VALUES (11, '南城县', 2, '5');
INSERT INTO `prov` VALUES (12, '黎川县', 2, '5');
INSERT INTO `prov` VALUES (13, '南丰县', 2, '5');
INSERT INTO `prov` VALUES (14, '临川区', 2, '5');
INSERT INTO `prov` VALUES (15, '杭州市', 1, '2');
INSERT INTO `prov` VALUES (16, '宁波市', 1, '2');
INSERT INTO `prov` VALUES (17, '温州市', 1, '2');
INSERT INTO `prov` VALUES (18, '上城区', 2, '15');
INSERT INTO `prov` VALUES (19, '西湖区', 2, '15');
INSERT INTO `prov` VALUES (20, '滨江区', 2, '15');
INSERT INTO `prov` VALUES (21, '鹿城区', 2, '17');
INSERT INTO `prov` VALUES (22, '龙湾区', 2, '17');
INSERT INTO `prov` VALUES (23, '瓯海区', 2, '17');
INSERT INTO `prov` VALUES (24, '江东区', 2, '16');
INSERT INTO `prov` VALUES (25, '江北区', 2, '16');
INSERT INTO `prov` VALUES (26, '镇海区', 2, '16');

-- ----------------------------
-- Table structure for root
-- ----------------------------
DROP TABLE IF EXISTS `root`;
CREATE TABLE `root`  (
  `id` int(11) NOT NULL,
  `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名',
  `password` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '密码',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'email',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '手机号',
  `describes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '个人描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of root
-- ----------------------------
INSERT INTO `root` VALUES (1, 'admin', '123', '12312312@qq.com', '13654852222', '一个热爱生活的管理员11');
INSERT INTO `root` VALUES (2, '王经理', '123', '1658964@qq.com', '13984847366', '高管');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户名，不可以重复',
  `password` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '123456' COMMENT '用户密码',
  `gmt_create` datetime(6) NULL DEFAULT NULL COMMENT '用户创建时间',
  `gmt_modified` datetime(6) NULL DEFAULT NULL COMMENT '用户上一次登录时间',
  `phone` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户手机号码，不可重复',
  `number` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '用户的身份证号码，不可以重复',
  `identity` tinyint(1) NULL DEFAULT NULL COMMENT '用户的身份（0为用户，一为快递员）',
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'email',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, '张三', '123', '2022-03-18 20:53:46.000000', '2022-03-18 20:53:49.000000', '13684686212', '32684419651346220x', 0, '123541@qq.com');
INSERT INTO `user` VALUES (2, '李四', '123456', '2022-03-18 21:27:59.000000', '2022-03-18 21:28:01.000000', '13684686201', '32684419651346312x', 0, '123456@qq.com');
INSERT INTO `user` VALUES (3, '王五', '123456', '2022-03-18 21:28:37.000000', '2022-03-18 21:28:39.000000', '13684686201', '326844196513463120', 0, '123456@qq.com');
INSERT INTO `user` VALUES (4, '挖傻', '123456', '2022-03-18 15:02:58.576000', '2022-03-18 15:02:58.576000', '12312', '123', 0, '123456@qq.com');
INSERT INTO `user` VALUES (6, '李师傅1', '123456', '2022-03-18 23:35:17.000000', '2022-03-18 23:35:19.000000', '13684847233', '362599199934610512', 1, '123456@qq.com');
INSERT INTO `user` VALUES (7, '王师傅', '123456', '2022-03-18 23:35:51.000000', '2022-03-18 23:35:53.000000', '13684847232', '362599199934610511', 1, '123456@qq.com');
INSERT INTO `user` VALUES (11, '1231', '123456', '2022-03-18 16:03:10.081000', '2022-03-18 16:03:10.081000', '13684847234', '362599199934610513', 0, '123456@qq.com');
INSERT INTO `user` VALUES (12, '挖傻傻的', '123456', '2022-03-18 16:03:17.224000', '2022-03-18 16:03:17.224000', '13684847234', '3123', 0, '123456@qq.com');
INSERT INTO `user` VALUES (14, '陈师傅', '123456', '2022-03-20 02:27:49.109000', '2022-03-20 02:27:49.109000', '13684686223', '362599199934610513', 1, '123456@qq.com');
INSERT INTO `user` VALUES (16, '123123', '123456', '2022-03-21 13:21:00.742000', '2022-03-21 13:21:00.742000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (17, '123', '123456', '2022-03-21 13:23:37.797000', '2022-03-21 13:23:37.797000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (18, NULL, '123456', '2022-03-22 03:20:18.390000', '2022-03-22 03:20:18.390000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (19, NULL, '123456', '2022-03-22 03:29:22.123000', '2022-03-22 03:29:22.123000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (20, NULL, '123456', '2022-03-22 03:31:11.999000', '2022-03-22 03:31:11.999000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (21, NULL, '123', '2022-03-22 04:07:28.436000', '2022-03-22 04:07:50.678000', NULL, NULL, 0, '123456@qq.com');
INSERT INTO `user` VALUES (22, '帕森斯', '123', '2022-03-22 04:10:21.581000', '2022-03-22 04:10:21.581000', NULL, NULL, 0, '123456@qq.com');

SET FOREIGN_KEY_CHECKS = 1;