Java项目:(小程序)全套商城系统(spring+spring mvc+mybatis+layui+微信小程)

/* Navicat Premium Data Transfer Source Server : dts_rds Source Server Type : MySQL Source Server Version : 50725 Source Host : localhost:3306 Source Schema : demo Target Server Type : MySQL Target Server Version : 50725 File Encoding : 65001 Date: 26/03/2020 19:56:40 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for dts_account_trace -- ---------------------------- DROP TABLE IF EXISTS `dts_account_trace`; CREATE TABLE `dts_account_trace` ( `id` int(11) NOT NULL AUTO_INCREMENT, `trace_sn` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作流水', `user_id` int(11) NOT NULL COMMENT '用户表的用户ID', `type` int(2) NULL DEFAULT NULL COMMENT '操作类型 0:系统结算 1:用户提现', `amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '操作金额', `total_amount` decimal(10, 2) NULL DEFAULT NULL COMMENT '总申请金额', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '申请时间', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号', `sms_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '短信提取码', `status` tinyint(3) NULL DEFAULT NULL COMMENT '审批状态', `trace_msg` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '消息内容', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '审批时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '账户流水表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_account_trace -- ---------------------------- INSERT INTO `dts_account_trace` VALUES (1, '121212', 1, 0, 12.00, 122.00, '2019-05-28 23:14:32', NULL, NULL, 2, NULL, NULL); INSERT INTO `dts_account_trace` VALUES (2, '122333', 1, 1, 22.00, 100.00, '2019-05-07 23:15:10', '13480*******', '125678', 2, NULL, NULL); INSERT INTO `dts_account_trace` VALUES (11, '20191117263674', 1, 1, 29.61, 249.61, '2019-11-17 00:29:35', '13480*******', NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` VALUES (12, '20191117852932', 2, 0, 2.68, 2.68, '2019-11-17 01:30:00', NULL, NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` VALUES (13, '20191208972291', 1, 0, 175.28, 295.28, '2019-12-08 01:30:00', NULL, NULL, 0, NULL, NULL); INSERT INTO `dts_account_trace` VALUES (14, '20191208768873', 2, 0, 6.79, 6.79, '2019-12-08 01:30:00', NULL, NULL, 0, NULL, NULL); -- ---------------------------- -- Table structure for dts_ad -- ---------------------------- DROP TABLE IF EXISTS `dts_ad`; CREATE TABLE `dts_ad` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '广告标题', `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '所广告的商品页面或者活动页面链接地址', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '广告宣传图片', `position` tinyint(3) NULL DEFAULT 1 COMMENT '广告位置：1则是首页', `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '活动内容', `start_time` datetime(0) NULL DEFAULT NULL COMMENT '广告开始时间', `end_time` datetime(0) NULL DEFAULT NULL COMMENT '广告结束时间', `enabled` tinyint(1) NULL DEFAULT 0 COMMENT '是否启动', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除', PRIMARY KEY (`id`) USING BTREE, INDEX `enabled`(`enabled`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '广告表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_ad -- ---------------------------- INSERT INTO `dts_ad` VALUES (1, '女装', '', 'https://juhuixing-dts.oss-cn-shenzhen.aliyuncs.com/ddlu7ce1ntzxrnaxqdyn.jpg', 1, '女装全场折扣低价', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:10:27', 0); INSERT INTO `dts_ad` VALUES (2, '美妆精选', '', 'https://juhuixing-dts.oss-cn-shenzhen.aliyuncs.com/dxzvhddk5b8olybkucdv.jpg', 1, '美妆精选会场', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:10:55', 0); INSERT INTO `dts_ad` VALUES (3, '儿童特惠', '', 'https://juhuixing-dts.oss-cn-shenzhen.aliyuncs.com/3bluuokv04qsdiunppk3.jpg', 1, '童装特惠', NULL, NULL, 1, '2018-02-01 00:00:00', '2019-10-05 21:11:19', 0); INSERT INTO `dts_ad` VALUES (4, '潮流男装', '', 'https://juhuixing-dts.oss-cn-shenzhen.aliyuncs.com/nlzvqw7jauvtnx6p8hts.jpg', 1, '潮流男装', NULL, NULL, 1, '2019-10-05 21:11:58', '2019-10-05 21:11:58', 0); -- ---------------------------- -- Table structure for dts_address -- ---------------------------- DROP TABLE IF EXISTS `dts_address`; CREATE TABLE `dts_address` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(63) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '收货人名称', `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户表的用户ID', `province_id` int(11) NOT NULL DEFAULT 0 COMMENT '行政区域表的省ID', `city_id` int(11) NOT NULL DEFAULT 0 COMMENT '行政区域表的市ID', `area_id` int(11) NOT NULL DEFAULT 0 COMMENT '行政区域表的区县ID', `address` varchar(127) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '具体收货地址', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码', `is_default` tinyint(1) NOT NULL DEFAULT 0 COMMENT '是否默认地址', `add_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', `deleted` tinyint(1) NULL DEFAULT 0 COMMENT '逻辑删除', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 76 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '收货地址表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of dts_address -- ---------------------------- INSERT INTO `dts_address` VALUES (23, '陈**', 1, 18, 215, 1980, '罗马广场猎鹰xxxxxx xxx', '13480******', 1, '2019-06-15 18:25:39', '2019-06-15 18:25:39', 0); INSERT INTO `dts_address` VALUES (24, '肖**', 7, 19, 231, 2124, '西乡街道黄田xxxxxx xxx', '18565******', 1, '2019-06-15 19:54:48', '2019-06-15 19:54:48', 0); INSERT INTO `dts_address` VALUES (25, '张**', 5, 1, 32, 381, '清华园南新街xxxxxx xxx', '17307******', 1, '2019-06-19 23:17:54', '2019-06-19 23:17:54', 0); INSERT INTO `dts_address` VALUES (26, '薛**', 13, 17, 201, 1881, '九峰景园里xxxxxx xxx', '18772******', 0, '2019-06-20 20:30:54', '2019-06-20 20:30:54', 0); INSERT INTO `dts_address` VALUES (28, '张**', 16, 19, 229, 2104, '横滘商业大楼xxxxxx xxx', '18924******', 1, '2019-06-21 00:54:00', '2019-06-21 00:54:00', 0); INSERT INTO `dts_address` VALUES (29, '刘**', 21, 18, 219, 2019, '湖南省邵阳市xxxxxx xxx', '13874******', 0, '2019-06-30 23:01:44', '2019-06-30 23:01:44', 1); INSERT INTO `dts_address` VALUES (30, '刘**', 21, 18, 219, 2019, '湖南省邵阳市xxxxxx xxx', '13874******', 0, '2019-07-01 08:50:18', '2019-07-01 08:50:18', 0); INSERT INTO `dts_address` VALUES (31, '邹**', 23, 19, 229, 2105, '红荔路1号动xxxxxx xxx', '15011******', 0, '2019-07-02 11:49:13', '2019-07-02 11:49:13', 0); INSERT INTO `dts_address` VALUES (32, '邹**', 2, 18, 215, 1980, '罗马广场猎鹰xxxxxx xxx', '19908******', 0, '2019-07-03 10:38:21', '2019-07-03 10:38:21', 0); INSERT INTO `dts_address` VALUES (33, '阳**', 19, 18, 219, 2019, '司门前镇沙坪xxxxxx xxx', '1584