Javascript + springboot星座占卜小程序开发源码

/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 50536 Source Host : localhost:3306 Source Schema : house Target Server Type : MySQL Target Server Version : 50536 File Encoding : 65001 Date: 21/02/2021 13:53:35 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for forum -- ---------------------------- DROP TABLE IF EXISTS `forum`; CREATE TABLE `forum` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '论坛标题', `kind` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '论坛分类', `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '论坛内容', `author` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '论坛作者', `time` datetime NULL DEFAULT NULL COMMENT '发布时间', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 23 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '论坛' ROW_FORMAT = Compact; -- ---------------------------- -- Records of forum -- ---------------------------- INSERT INTO `forum` VALUES (9, '大家的狗平时都吃什么呀', '122', '吃的是特价狗粮', 'z', '2021-01-17 00:00:00'); INSERT INTO `forum` VALUES (21, '撒打算', NULL, '萨达萨达是', 'z', NULL); INSERT INTO `forum` VALUES (22, '你最近好吗', NULL, '我很好特别好', 'z', NULL); -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号', `table_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作 sub主子表操作）', `package_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`table_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = Compact; -- ---------------------------- -- Records of gen_table -- ---------------------------- INSERT INTO `gen_table` VALUES (1, 'forum', '论坛', NULL, NULL, 'Forum', 'crud', 'com.ruoyi.project.system', 'system', 'forum', '论坛', 'ruoyi', '0', '/', NULL, 'admin', '2021-01-10 20:50:28', '', NULL, NULL); INSERT INTO `gen_table` VALUES (2, 'health', '宠物健康检测', NULL, NULL, 'Health', 'crud', 'com.ruoyi.project.system', 'system', 'health', '宠物健康检测', 'ruoyi', '0', '/', NULL, 'admin', '2021-01-10 20:50:28', '', NULL, NULL); INSERT INTO `gen_table` VALUES (3, 'periphery', '宠物周边推荐', NULL, NULL, 'Periphery', 'crud', 'com.ruoyi.project.system', 'system', 'periphery', '宠物周边推荐', 'ruoyi', '0', '/', NULL, 'admin', '2021-01-10 20:50:28', '', NULL, NULL); INSERT INTO `gen_table` VALUES (4, 'pets', '宠物基本信息', NULL, NULL, 'Pets', 'crud', 'com.ruoyi.project.system', 'system', 'pets', '宠物基本信息', 'ruoyi', '0', '/', NULL, 'admin', '2021-01-10 20:50:28', '', NULL, NULL); INSERT INTO `gen_table` VALUES (5, 'reply', '论坛交流', NULL, NULL, 'Reply', 'crud', 'com.ruoyi.project.system', 'system', 'reply', '论坛交流', 'ruoyi', '0', '/', NULL, 'admin', '2021-01-10 20:50:28', '', NULL, NULL); INSERT INTO `gen_table` VALUES (6, 'house_collection', '收藏', NULL, NULL, 'HouseCollection', 'crud', 'com.ruoyi.project.system', 'system', 'collection', '收藏', 'author', '0', '/', NULL, 'admin', '2021-02-18 22:14:19', '', NULL, NULL); INSERT INTO `gen_table` VALUES (7, 'house_contract', '租房合同', NULL, NULL, 'HouseContract', 'crud', 'com.ruoyi.project.system', 'system', 'contract', '租房合同', 'author', '0', '/', NULL, 'admin', '2021-02-18 22:14:20', '', NULL, NULL); INSERT INTO `gen_table` VALUES (8, 'house_house', '房源信息', NULL, NULL, 'HouseHouse', 'crud', 'com.ruoyi.project.system', 'system', 'house', '房源信息', 'author', '0', '/', '{\"parentMenuId\":\"\",\"treeName\":\"\",\"treeParentCode\":\"\",\"parentMenuName\":\"\",\"treeCode\":\"\"}', 'admin', '2021-02-18 22:14:20', '', '2021-02-18 22:15:13', ''); INSERT INTO `gen_table` VALUES (9, 'house_opinion', '反馈意见', NULL, NULL, 'HouseOpinion', 'crud', 'com.ruoyi.project.system', 'system', 'opinion', '反馈意见', 'author', '0', '/', NULL, 'admin', '2021-02-18 22:14:20', '', NULL, NULL); INSERT INTO `gen_table` VALUES (10, 'house_pay', '支付房租', NULL, NULL, 'HousePay', 'crud', 'com.ruoyi.project.system', 'system', 'pay', '支付房租', 'author', '0', '/', NULL, 'admin', '2021-02-18 22:14:20', '', NULL, NULL); -- ---------------------------- -- Table structure for gen_table_column -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号', `table_id` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci