校园二手交易网站(springboot+ssm+vue+mysql8.x)含8000字文档含演示视频.zip

/* Navicat Premium Data Transfer Source Server : 本地mysql Source Server Type : MySQL Source Server Version : 80033 Source Host : localhost:3306 Source Schema : second_hand_trading Target Server Type : MySQL Target Server Version : 80033 File Encoding : 65001 Date: 15/11/2023 17:41:29 */ DROP DATABASE IF EXISTS second_hand_trading ; CREATE DATABASE second_hand_trading CHARACTER SET utf8; use second_hand_trading ; SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for sh_address -- ---------------------------- DROP TABLE IF EXISTS `sh_address`; CREATE TABLE `sh_address` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `consignee_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收货人姓名', `consignee_phone` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '收货人手机号', `province_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '省', `city_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '市', `region_name` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '区', `detail_address` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '详细地址', `default_flag` tinyint(0) NOT NULL COMMENT '是否默认地址', `user_id` bigint(0) NOT NULL COMMENT '用户主键id', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id_index`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of sh_address -- ---------------------------- INSERT INTO `sh_address` VALUES (1, 'user9', '13011110009', '江苏省', '南通市', '崇川区', '花园一单元一号楼', 1, 10); INSERT INTO `sh_address` VALUES (2, 'user8', '13011110008', '江苏省', '南通市', '崇川区', '888', 1, 9); INSERT INTO `sh_address` VALUES (27, 'MZ', '13011110000', '河南省', '新乡市', '原阳县', '测试测试', 1, 1); INSERT INTO `sh_address` VALUES (28, '1211111111', '1212', '天津市', '市辖区', '河东区', '212', 1, 2); INSERT INTO `sh_address` VALUES (29, '下雨', '1788888888', '天津市', '市辖区', '河西区', '北京', 1, 3); -- ---------------------------- -- Table structure for sh_admin -- ---------------------------- DROP TABLE IF EXISTS `sh_admin`; CREATE TABLE `sh_admin` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `account_number` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '管理员账号', `admin_password` varchar(16) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '密码', `admin_name` varchar(8) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '管理员名字', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `account_number`(`account_number`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of sh_admin -- ---------------------------- INSERT INTO `sh_admin` VALUES (1, '11', '123123', '超级管理员'); INSERT INTO `sh_admin` VALUES (2, '22', '123123', '管理员1'); INSERT INTO `sh_admin` VALUES (3, '33', '123123', '管理员2'); INSERT INTO `sh_admin` VALUES (11, '44', '123123', '管理员3'); INSERT INTO `sh_admin` VALUES (12, '55', '123123', '管理员4'); -- ---------------------------- -- Table structure for sh_favorite -- ---------------------------- DROP TABLE IF EXISTS `sh_favorite`; CREATE TABLE `sh_favorite` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增主键id', `create_time` datetime(0) NOT NULL COMMENT '加入收藏的时间', `user_id` bigint(0) NOT NULL COMMENT '用户主键id', `idle_id` bigint(0) NOT NULL COMMENT '闲置物主键id', PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `user_id`(`user_id`, `idle_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 46 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of sh_favorite -- ---------------------------- INSERT INTO `sh_favorite` VALUES (42, '2021-09-02 07:21:59', 9, 80); INSERT INTO `sh_favorite` VALUES (43, '2022-10-22 22:20:08', 4, 90); INSERT INTO `sh_favorite` VALUES (44, '2023-01-08 10:23:09', 3, 93); INSERT INTO `sh_favorite` VALUES (45, '2023-01-08 17:56:57', 3, 98); INSERT INTO `sh_favorite` VALUES (46, '2023-01-08 17:58:11', 3, 97); -- ---------------------------- -- Table structure for sh_idle_item -- ---------------------------- DROP TABLE IF EXISTS `sh_idle_item`; CREATE TABLE `sh_idle_item` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `idle_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '闲置物名称', `idle_details` varchar(2048) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '详情', `picture_list` varchar(1024) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '图集', `idle_price` decimal(10, 2) NOT NULL COMMENT '价格', `idle_place` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '发货地区', `idle_label` int(0) NOT NULL COMMENT '分类标签', `release_time` datetime(0) NOT NULL COMMENT '发布时间', `idle_status` tinyint(0) NOT NULL COMMENT '状态（发布1、下架2、删除0）', `user_id` bigint(0) NOT NULL COMMENT '用户主键id', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id_index`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 105 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of sh_idle_item -- ---------------------------- INSERT INTO `sh_idle_item` VALUES (1, '111', '111', '[\"http://localhost:8080/image?imageName=file16866307653031002壁纸.jpg\"]', 20.01, '市辖区', 1, '2023-06-13 04:32:47', 2, 1); INSERT INTO `sh_idle_item` VALUES (2, '运动鞋', '跑步非常舒服 回弹性好', '[\"http://localhost:8080/image?imageName=file16868385096121002运动鞋.jpg\"]', 100.00, '市辖区', 3, '2023-06-15 14:15:11', 1, 1); INSERT INTO `sh_idle_item` VALUES (3, '电风扇', '贼凉快', '[\"http://localhost:8080/image?imageName=file16868385807991003风扇.jpg\"]', 120.00, '唐山市', 2, '2023-06-15 14:16:37', 1, 1); INSERT INTO `sh_idle_item` VALUES (4, '加湿器', '干燥空气瞬间变湿', '[\"http://localhost:8080/image?imageName=file16868386408251004file16513152624181010加湿器.jpg\"]', 50.00, '阳泉市', 1, '2023-06-15 14:19:20', 1, 1); INSERT INTO `sh_idle_item` VALUES (5, '考研单词书', '考研背单词必备', '[\"http://localhost:8080/image?imageName=file16868387852141005file16527758200311002考研单词书.jpg\"]', 10.00, '市辖区', 4, '2023-06-15 14:20:34', 1, 1); -- ---------------------------- -- Table structure for sh_message -- ---------------------------- DROP TABLE IF EXISTS `sh_message`; CREATE TABLE `sh_message` ( `id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `user_id` bigint(0) NOT NULL COMMENT '用户主键id', `idle_id` bigint(0) NOT NULL COMMENT '闲置主键id', `content` varchar(256) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT '留言内容', `create_time` datetime(0) NOT NULL COMMENT '留言时间', `to_user` bigint(0) NOT NULL COMMENT '所回复的用户', `to_message` bigint(0) NULL DEFAULT NULL COMMENT '所回复的留言', PRIMARY KEY (`id`) USING BTREE, INDEX `user_id_index`(`user_id`) USING BTREE, INDEX `idle_id_index`(`idle_id`) USING BTREE, INDEX `to_user_index`(`to_user`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 47