express+mysql+vue,从零搭建一个商城管理系统16-收货地址（全国省市县名称和code列表）

/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 80028 Source Host : localhost:3306 Source Database : express_service Target Server Type : MYSQL Target Server Version : 80028 File Encoding : 65001 Date: 2024-03-19 18:46:35 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for address -- ---------------------------- DROP TABLE IF EXISTS `address`; CREATE TABLE `address` ( `id` int NOT NULL AUTO_INCREMENT, `createId` varchar(255) DEFAULT NULL COMMENT '创建人ID', `createName` varchar(255) DEFAULT NULL COMMENT '创建人姓名', `addressId` varchar(255) DEFAULT NULL COMMENT '地址ID', `provinceCode` varchar(255) DEFAULT NULL COMMENT '省code', `provinceName` varchar(255) DEFAULT NULL COMMENT '省', `cityCode` varchar(255) DEFAULT NULL COMMENT '市code', `cityName` varchar(255) DEFAULT NULL COMMENT '市', `areaCode` varchar(255) DEFAULT NULL COMMENT '县code', `areaName` varchar(255) DEFAULT NULL COMMENT '县', `fullAddress` varchar(255) DEFAULT NULL COMMENT '详细地址', `recipientName` varchar(255) DEFAULT NULL COMMENT '收件人', `phone` varchar(30) DEFAULT NULL COMMENT '手机号码', `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of address -- ---------------------------- INSERT INTO `address` VALUES ('1', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '326c9b3d7e6dd5ec6deee76347c13506', '110000', '北京市', '110100', '市辖区', '110108', '海淀区', '五道口路xxxxxxxxxxxxx', 'xxx', '1891193xxxx', '2024-03-19 10:24:55', '2024-03-19 10:24:55'); INSERT INTO `address` VALUES ('2', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', 'c36aa942cae8499b2c695acca9853b21', '110000', '北京市', '110100', '市辖区', '110108', '海淀区', '西小口路xxxxxxxxxxxxx', 'zzz', '1891193zzzz', '2024-03-19 10:25:48', '2024-03-19 10:25:48'); -- ---------------------------- -- Table structure for cart -- ---------------------------- DROP TABLE IF EXISTS `cart`; CREATE TABLE `cart` ( `id` int NOT NULL AUTO_INCREMENT, `userId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `count` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of cart -- ---------------------------- INSERT INTO `cart` VALUES ('2', '9e14ebba3be0ae546374e8f5a49f9e80', '79194be0b10509d407ec414e297da595', 'shop03', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈500ml', '4.5', '5', '500ml/瓶', '2024-03-14 03:23:12', '2024-03-14 03:23:48'); INSERT INTO `cart` VALUES ('3', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'a1787a5e48133e3b688412c27643df80', '大辣片', '4.9', '1', '240克/袋', '2024-03-14 03:26:40', '2024-03-14 03:26:40'); INSERT INTO `cart` VALUES ('4', '9e14ebba3be0ae546374e8f5a49f9e80', 'a81184a745ad97a4de19823f9782f733', 'shop02', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '4.9', '2', '35克/袋', '2024-03-14 03:27:20', '2024-03-14 03:27:33'); INSERT INTO `cart` VALUES ('5', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '8.8', '1', '200克/盒', '2024-03-14 03:30:26', '2024-03-14 03:30:26'); INSERT INTO `cart` VALUES ('6', '9e14ebba3be0ae546374e8f5a49f9e80', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '6.4', '3', '160克/罐', '2024-03-14 03:31:03', '2024-03-14 03:49:04'); -- ---------------------------- -- Table structure for goods -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int NOT NULL AUTO_INCREMENT, `goodsId` varchar(255) DEFAULT NULL, `goodsName` varchar(255) NOT NULL, `createId` varchar(255) DEFAULT NULL, `shopId` varchar(255) DEFAULT NULL, `shopName` varchar(255) DEFAULT NULL, `price` float DEFAULT NULL, `inventory` int DEFAULT NULL, `specs` varchar(255) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `goodsName` (`goodsName`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '3984cac360808573a7b703b61a66d0fe', '奥利奥原味饼干', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '8.8', '97', '200克/盒', '2024-03-13 08:08:51', '2024-03-18 10:39:26'); INSERT INTO `goods` VALUES ('5', '94f2965af1c719ade377fd9f85b61e1f', '乐事薯片', '94bca74490de0f84e1f478ed602123d3', '098a0c4828d7d0c78f42e6124f911a77', 'shop01', '6.4', '191', '160克/罐', '2024-03-13 08:37:07', '2024-03-18 10:39:26'); INSERT INTO `goods` VALUES ('6', 'dd427517fbdc6760a14b11ee84772685', '卫龙辣条', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '994', '35克/袋', '2024-03-14 02:45:20', '2024-03-18 10:39:26'); INSERT INTO `goods` VALUES ('7', '52f20f495e66657126497715130a2997', '亲嘴铜锣烧', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '1.2', '2400', '10克/袋', '2024-03-14 02:46:01', '2024-03-14 02:46:01'); INSERT INTO `goods` VALUES ('8', 'a1787a5e48133e3b688412c27643df80', '大辣片', '1c270113be21412c87b87aff22fe19ec', 'a81184a745ad97a4de19823f9782f733', 'shop02', '4.9', '197', '240克/袋', '2024-03-14 02:46:33', '2024-03-18 10:39:26'); INSERT INTO `goods` VALUES ('9', '59ab7156aab608c14f90ddd7e1dcbdd4', '娃哈哈100ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '5.9', '2000', '6瓶/排', '2024-03-14 02:47:53', '2024-03-14 02:47:53'); INSERT INTO `goods` VALUES ('10', 'd1d828d718d4db54e1790e17c69055dc', '娃哈哈220g', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '7.8', '2000', '4瓶/排', '2024-03-14 02:49:06', '2024-03-14 02:49:06'); INSERT INTO `goods` VALUES ('11', '552528655c60297fa70d2ca1cb96f995', '娃哈哈500ml', '69a41e3cc40e980da8d7b7d36ef273c2', '79194be0b10509d407ec414e297da595', 'shop03', '4.5', '485', '500ml/瓶', '2024-03-14 02:49:38', '2024-03-18 10:39:26'); -- ---------------------------- -- Table structure for order -- ---------------------------- DROP TABLE IF EXISTS `order`; CREATE TABLE `order` ( `id` int NOT NULL AUTO_INCREMENT, `orderId` varchar(255) DEFAULT NULL, `userId` varchar(255) DEFAULT NULL, `userName` varchar(255) DEFAULT NULL, `total` float DEFAULT NULL, `goods` varchar(3000) DEFAULT NULL, `createdAt` datetime NOT NULL, `updatedAt` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3; -- ---------------------------- -- Records of order -- ---------------------------- INSERT INTO `order` VALUES ('4', '2ae440ce4b3c8fa8513a58e25a3ba1b2', '9e14ebba3be0ae546374e8f5a49f9e80', 'long001', '51.95', '[{\"goodsId\":\"3984cac360808573a7b703b61a66d0fe\",\"goodsName\":\"奥利奥原味饼干\",\"price\":8.8,\"count\":1},{\"goodsId\":\"94f2965af1c719ade377fd9f85b61e1f\",\"goodsName\":\"乐事薯片\",\"price\":6.4,\"count\":3},{\"goodsId\":\"a1787a5e48133e3b688412c27643df80\",\"goodsName\":\"大辣片\",\"price\":4.9,\"count\":1},{\"goodsId\":\"dd427517fbdc6760a14b11ee84772685\",\"goodsName\":\"卫龙辣条\",\"price\":4.9,\"count\":2},{\"goodsId\":\"552528655c60297fa70d2ca1cb96f995\",\"goodsName\":\"娃哈哈500ml